How to achieve master- master replication between more than two postgresql databases?

799 Views Asked by At

I would like to be able to setup a master-master replication between more than two postgresql databases in the following way:

Consider three databases namely db_main, db_1, db_2. There is a bi-directional replication setup (swap sync maybe?, in Bucardo terms) between db_main and db1 and another between db_main and db_2. While db_1 and db_2 are not even directly connected, if I create table1 on db_1 and table2 on db_2 then both table1 and table2 should propagate to all three databases.

Is such a setup even possible? if yes how? what level of consistency? will the solution tolerate failures such as message loss due to network failure ?

Thank you in advance.

0

There are 0 best solutions below