| From: | Joshua Tolley <eggyknap(at)gmail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Bidirectional replication |
| Date: | 2011-05-06 03:05:24 |
| Message-ID: | 4dc3657b.aa1e440a.2735.ffffc578@mx.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-05-06 03:13:55 | Re: Bidirectional replication |
| Previous Message | John Cheng | 2011-05-06 03:03:28 | Re: Cannot reproduce why a query is slow |