Re: Master-master replication with PostgreSQL - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Master-master replication with PostgreSQL
Date
Msg-id b5ba7786ef90138c0586adcac8e04d18@biglumber.com
Whole thread Raw
In response to Re: Master-master replication with PostgreSQL  (Vivek Khera <vivek@khera.org>)
List 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@turnstep.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-----



pgsql-general by date:

Previous
From: "Jimmy Choi"
Date:
Subject: "vacuum" and "cluster"
Next
From: Craig Ringer
Date:
Subject: Re: "vacuum" and "cluster"