Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com 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

1 Answer 1

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

 
discard

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