Re: Cascading Replication Multi Master

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Rahul Saha <rahul(dot)blooming(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Cascading Replication Multi Master
Date: 2014-05-21 05:37:15
Message-ID: CAFnxYwgcUGEPEz=FKzzHxJ7rGrGTzP775Lan3hy7QQXy2ypCEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, May 20, 2014 at 8:46 PM, Rahul Saha <rahul(dot)blooming(at)gmail(dot)com>wrote:

> Do we have solution for kind of scenario ? I believe Bucurdo is a soluion
> but I am not sure, it will do cascading replication from A to B and B to C.
>

Yes, Bucardo will do what you describe.

The configuration is a little more complicated if you want changes on C to
replicate back to B (and, naturally, A<->B, plus B->C is more involved than
just A<->B), but I've had a similar setup (where B replicates to C, but not
the reverse) in production before, several years ago now.

rls

--
:wq

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message , Roy 2014-05-22 04:19:12 Recovery of psql db data
Previous Message Rahul Saha 2014-05-21 03:46:16 Cascading Replication Multi Master