On Thu, 30 Mar 2006 09:22:38 -0500 Robert Treat <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
