We would like to implement openerp in multiple locations,but datas from all the location should be synced? Is it possible to have multi master replication of database(postgres) with openerp?
What is the minimum system requirements for 300 users? Can we use openerp on centos 6 for production?
I don't know if it's too late, but since there is no other answer yet, I'll chip in the following. On a project where we needed multi-master replication of PostgreSQL databases, we had success with bucardo. The project was not related to OpenERP, but since it is database replication you are looking for, you might as well give it a shot.
It was quite some time ago, and I'm fairly old and no longer remember things very well, but IIRC bucardo was a bit of a pain to set up, but once it was it worked well, at least for what we needed it for.
There are a few other replication systems for pgsql as well, some of which support multi-master replication. But I don't have any experience with them. You'd have to test them until you find one that suits you.
In an OpenERP context I believe that you may also have to take a few other things into consideration, depending on how you are storing your attachements, for instance. But if they are on the file system, then I guess a tool like rsync might be helpful. But I'm not sure if OpenERP 7 still stores any objects on the file system. Maybe somebody who knows more can shed light on that issue?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/25/13, 1:22 PM|
|Seen: 4107 times|
|Last updated: 6/4/15, 12:03 AM|