[Bucardo-general] Bucardo Replication question on sequences

Greg Sabino Mullane greg at endpoint.com
Wed May 26 14:34:52 UTC 2010

> > question. We have sequences in our master database. In case of disaster, if
> > the slave becomes the main database, How can I handle the sequences. can you
> > please share your thoughts. Appreciate your help

> you need to change sequences
> machine 1  sequences = 1, 3, 5, 7, 9
> machine 2  sequences = 0, 2, 4, 6, 8

Offset sequences is a common strategy on a master-master setup, but I think 
the original poster was asking about a master-slave scenario. In that case, you 
can simply add the sequences to your sync, and Bucardo will replicate them. For 

bucardo_ctl add your_sequence_name db=dbname

bucardo_ctl update sync mysync add your_sequence_name

Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100526/b5005a91/attachment.bin 

More information about the Bucardo-general mailing list