Adeyinka wrote: > Hi All, > > My intention is to use Bucardo in a multi-master setup, with the two masters > connected over a flapping WAN link. > Both master servers are being updated simultaneously. > > I have searched the internet for days without success, trying to find > directions on how exactly to modify sequence increments on the two servers. > The databases on these two servers are already populated. The PostgreSQL > documentation is quite vague to me. > > Can someone provide detailed instructions on how to go about this? > I am running PostgreSQL 9.1 on Ubuntu Server 12.04 64bit. >
Very simply: Don't replicate the sequences, then set the sequences to odds on one server and evens on the other with an increment of 2 on both (so that they stay either odds or evens) ... if you're running more than 2 masters, similar applies, just make the increment appropriate .. eg you could set an increment of 10 and have every server a base number which is uniq in 0-9 ... giving upto 10 servers. Regards, -- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
