Re: Cascading Replication Multi Master - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: Cascading Replication Multi Master
Date
Msg-id CAFnxYwgcUGEPEz=FKzzHxJ7rGrGTzP775Lan3hy7QQXy2ypCEg@mail.gmail.com
Whole thread Raw
In response to Cascading Replication Multi Master  (Rahul Saha <rahul.blooming@gmail.com>)
List pgsql-admin
On Tue, May 20, 2014 at 8:46 PM, Rahul Saha <rahul.blooming@gmail.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

pgsql-admin by date:

Previous
From: Rahul Saha
Date:
Subject: Cascading Replication Multi Master
Next
From: ", Roy"
Date:
Subject: Recovery of psql db data