[Bucardo-general] Bucardo Replication question on sequences

[akp geek]

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.

Regards


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,
> you
> can simply add the sequences to your sync, and Bucardo will replicate them.
> For
> example:
>
> 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...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100526/6d314cc2/attachment.html