Skip site navigation (1) Skip section navigation (2)

Re: Bidirectional replication

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Bidirectional replication
Date: 2011-05-03 06:31:49
Message-ID: 4DBFA155.3040400@compulab.co.il (view raw or flat)
Thread:
Lists: pgsql-general
On 05/03/2011 09:15 AM, tushar nehete wrote:

> Hi,
> Is there any way to do bidirectional replication for Postgresql Plus 
> Advance Server 8.4.5?
>
> I tried SLONY-I but its master-slave asynchronous replication.
> Can we configure master-master replication by slony?
>
>
> Or is there any trusted tool to do it?
>
>
> Regards,
> Tushar
I have heard good things about Bucardo, though I haven't tried it myself 
yet. I was warned that it would be risky to have 2 masters that have the 
same tables modified in both because of issues such as delayed sync, 
race conditions and other such goodies that may corrupt the meaning of 
the data.

In response to

Responses

pgsql-general by date

Next:From: Karsten HilbertDate: 2011-05-03 08:12:17
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Previous:From: John R PierceDate: 2011-05-03 06:31:28
Subject: Re: Bidirectional replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group