Re: Master-master replication with PostgreSQL

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Master-master replication with PostgreSQL
Date: 2008-04-16 15:43:46
Message-ID: b5ba7786ef90138c0586adcac8e04d18@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

>> Try with bucardo ("http://bucardo.org/") may be help you :).

> Doesn't bucardo handle conflicts with "whichever one I apply last
> wins"? That doesn't seem safe in all situations (or any, IMO).

With Bucardo, conflict handling is chosen as a standard method
(of which one is "latest") or a custom handler. "Latest" has its
places, but the usual recommendation is to pick one of the servers
as the trusted source, or to write your own handler based on your
business logic.

http://www.bucardo.org/bucardo.html#BucardoConflictHandling

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200804161143
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkgGHogACgkQvJuQZxSWSshdAACg6ouoh909Ts1r40YwGscax2M1
y+gAoOQdOG7ToqnYNfVQ+3sS8ypBrpFS
=NC0p
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-04-16 16:01:26 Re: "vacuum" and "cluster"
Previous Message Vance Maverick 2008-04-16 15:41:25 table as log (multiple writers and readers)