[Bucardo-general] Multi-master replication and sequences

Federico Fanton federico at panizzolo.it
Tue Jul 14 12:23:09 UTC 2015

On 14/07/2015 14:18, Michelle Sullivan wrote:

>> 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?

> 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.

What do you mean by "server ID"? Defining PKs as "nodeN_" + sequence? 
Something like this?

More information about the Bucardo-general mailing list