[clug] Disconnected multi-master DB?

Chris Smart mail at christophersmart.com
Tue Nov 4 21:52:17 GMT 2008

Anyone have experience setting up asynchronous multi-master PostgreSQL (or
MySQL) servers, that are disconnected 99.99% of the time? (Connected only
for purposes of synchronisation.)

At work we have two completely separate networks with PostgreSQL that must
(at some stage) hold the same records, all the while being available to take
new data separately.

Server 1 takes in some records while at the same time server 2 takes in some
other records.
Sync the data so that both servers hold the same records (without conflicts)
while not using uniquely identifiable primary keys.


More information about the linux mailing list