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.