[Bucardo-general] Multi-master replication and sequences

Michelle Sullivan michelle at sorbs.net
Tue Jul 14 12:18:00 UTC 2015

Federico Fanton wrote:
> Hi everyone!
> I'm (still) setting up multi-master replication between two nodes.
> What is the recommended way to handle sequences? I've seen posts
> saying that you should make one instance generate even numbers while
> the other should generate odd numbers, but they were quite old
> posts... Is this still the recommended way?
> Many thanks!
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Sequences can be replicated but if you're going to have concurrent
inserts into both DBs you probably should go with the offset sequences
or do as I did add a 'server ID' to the pks and not worry about
replicating the sequences.



Michelle Sullivan

More information about the Bucardo-general mailing list