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
-
Use Bucardo. Slony is great for master-slave replication, also it doesn't have an option for master-master.Diego Vargas– Diego Vargas2013-02-13 15:50:51 +00:00Commented Feb 13, 2013 at 15:50
Add a comment
|
1 Answer
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.Scott Marlowe– Scott Marlowe2013-01-18 07:42:10 +00:00Commented Jan 18, 2013 at 7:42