[Bucardo-general] PostgreSQL/Bucardo Sequences

Michelle Sullivan michelle at sorbs.net
Sun Nov 9 13:59:06 UTC 2014

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.


Michelle Sullivan

More information about the Bucardo-general mailing list