[GENERAL] Slony-I for circular replication

2006-03-30 Thread Bozhidar Mihaylov
Hi All;   Can Slony-I be used for circular replication (A B  A) or there is some kind of problem with locking or anything else? If I avoid insert conflicts will the following scenario succeed for the updates :    A: X.balance-= 5    B: X.balance-= 3    A receives the update from B (X.balance -= 3)

Re: [GENERAL] Slony-I for circular replication

2006-03-30 Thread Richard Huxton
Bojidar Mihajlov wrote: Hi All; Can Slony-I be used for circular replication (A B A) or there is some kind of problem with locking or anything else? No - Slony is an asynchronous single-master replication scheme. As such changes are only allowed at a "master" node. You might want to loo

[GENERAL] Slony-I for circular replication

2006-03-30 Thread Bojidar Mihajlov
Hi All; Can Slony-I be used for circular replication (A B A) or there is some kind of problem with locking or anything else? If I avoid insert conflicts will the following scenario succeed for the updates : A: X.balance-= 5 B: X.balance-= 3 A receives the update from B (X.balance -= 3)