[Bucardo-general] PostgreSQL/Bucardo Sequences
michelle at sorbs.net
Sun Nov 9 13:59:06 UTC 2014
> 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.
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.
More information about the Bucardo-general