Re: Slony-I for circular replication - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Re: Slony-I for circular replication
Date
Msg-id 20060330101521.30a9a77e.darcy@druid.net
Whole thread Raw
In response to Re: Slony-I for circular replication  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Slony-I for circular replication
List pgsql-hackers
On Thu, 30 Mar 2006 09:22:38 -0500
Robert Treat <xzilla@users.sourceforge.net> wrote:
> On Thursday 30 March 2006 08:34, Bojidar Mihajlov wrote:
> > Can Slony-I be used for circular replication (A
> > <replicates> B <replicates> A)
> > or there is some kind of problem with locking or
> > anything else?
> 
> Sounds like you want some kind of synchronous federated multi-master 
> repication... which Slony-I wont do and I don't know of any system that will.  
> You might be able to get some of that functionality using views and multiple 
> replication sets, but that conversation really ought to take place on a more 
> appropriate list, like the Slony list for example. 

I had to do multi-master replication for a major project and we wound
up writing our own replication system.  The problem is that this sort of
thing really has to be based on your own business rules.  There is no
way to make it generic.  At least, that was the conclusion we came to.

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: control pg_hba.conf via SQL
Next
From: "A.M."
Date:
Subject: Re: control pg_hba.conf via SQL