[Bucardo-general] Bucardo Replication question on sequences
akpgeek at gmail.com
Wed May 26 17:25:29 UTC 2010
Thank you for the input. I have small a clarification to ask, I have started
the replication and it is in the process. Can I run the following commands
to take care of the sequences.
On Wed, May 26, 2010 at 10:34 AM, Greg Sabino Mullane <greg at endpoint.com>wrote:
> > > 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,
> can simply add the sequences to your sync, and Bucardo will replicate them.
> 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 --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general