Odoo Help


Openerp with multimaster DB replication

on 3/25/13, 1:22 PM 5,518 views


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?

Please help with this. It must be one of the most crucial questions for a multi-site openerp installation. You cannot compare openERP to the likes of SAP if there isnt a solid way to do this. I'm looking at http://www.enterprisedb.com/products-services-training/products-overview/xdb-replication-server-multi-master - looks like a potentially good option if it works as advertised. Anyone got a better way to do this??

Timothy Solomon
on 4/9/13, 6:34 AM

This is a must have feature for geographical distributed installations with poor internet connectivity. Any updates?

Osoul for Technology and Software Development
on 4/29/13, 10:32 AM
Lorenzo Cabrini
On 4/9/13, 5:25 PM

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?

Intigra Technolab
On 5/14/15, 11:08 AM

Read this.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

6 follower(s)


Asked: 3/25/13, 1:22 PM
Seen: 5518 times
Last updated: 6/4/15, 12:03 AM