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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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