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
  • Use Bucardo. Slony is great for master-slave replication, also it doesn't have an option for master-master. Feb 13 '13 at 15:50

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

  • Bucardo++. Otherwise I'd look at using some kind of cross database replication with slony. Jan 18 '13 at 7:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy