Re: Bidirectional replication - Mailing list pgsql-general

From Joshua Tolley
Subject Re: Bidirectional replication
Date
Msg-id 4dc3657b.aa1e440a.2735.ffffc578@mx.google.com
Whole thread Raw
In response to Re: Bidirectional replication  (John R Pierce <pierce@hogranch.com>)
Responses Re: Bidirectional replication
List pgsql-general
On Mon, May 02, 2011 at 11:31:28PM -0700, John R Pierce wrote:
> AFAIK, the only postgres replication systems that even pretend to
> support master-master are things like Bucardo that do the replication at
> the SQL layer, by sending all update/insert/delete commands to both
> servers, and under certain sequences of concurrent queries, you could
> end up with different results on the two servers.

Actually, Bucardo doesn't do statement replication. It, like Slony for
instance, replicates data, not SQL statements. And as you pointed out, it does
do bidirectional replication in a way that's sufficient for some use cases.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Attachment

pgsql-general by date:

Previous
From: John Cheng
Date:
Subject: Re: Cannot reproduce why a query is slow
Next
From: John R Pierce
Date:
Subject: Re: Bidirectional replication