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

From Robert Treat
Subject Re: Slony-I for circular replication
Date
Msg-id 200603300922.38542.xzilla@users.sourceforge.net
Whole thread Raw
In response to Slony-I for circular replication  (Bojidar Mihajlov <bmihajlov@yahoo.com>)
Responses Re: Slony-I for circular replication  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
On Thursday 30 March 2006 08:34, Bojidar Mihajlov wrote:
> Hi All;
>
> 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. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: control pg_hba.conf via SQL
Next
From: Tino Wildenhain
Date:
Subject: Re: control pg_hba.conf via SQL