Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two projects working on different databases. The problem is: I need to replicate changes in the databases only for a few tables. I need it to synchronize the data. Need an advice how can I solve it. I have PostgreSQL 9.1 DB servers, the replication schema is master-master. What I found is:

  1. Rubyrep
  2. Bucardo
  3. Postgres-XC
share|improve this question

migrated from Jan 17 '13 at 1:31

This question came from our site for professional and enthusiast programmers.

Use Bucardo. Slony is great for master-slave replication, also it doesn't have an option for master-master. – Diego Vargas Feb 13 '13 at 15:50

If you need to replicate only a few tables master-master, then Bucardo is probably your best bet.

share|improve this answer
Bucardo++. Otherwise I'd look at using some kind of cross database replication with slony. – Scott Marlowe Jan 18 '13 at 7:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.