4 ms·

Here's a table: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Comparison_matrix https://wiki.postgresql.org/wiki/Replication,

Here's a table: https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling#Comparison_matrix https://wiki.postgresql.org/wiki/Replication,_Clustering,_an... It's worth noting that BDR is much more mature that the table indicates and is probably the easiest to set up today (for up to 48 masters in a pool).

Florin_Andrei 11y ago
I did a test with a data backup from our live DB, and BDR fails in mysterious ways. I had a two-node cluster, and tried to restore the DB into one node. Failed, I think, when it was rebuilding indexes (no useful messages in the logs), with some scary warnings also when it was importing some big tables. Most of the data made it across network to the other node - emphasis on most. I really wanted this thing to work. :( On paper it looks great.