[Bucardo-general] Bucardo Replication question on sequences

[Itamar Reis Peixoto]

On Tue, May 25, 2010 at 2:18 PM, akp geek <akpgeek at gmail.com> wrote:
> Dear All -
>                 We have setup bucardo and running with no issues. I have a
> 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
>
> Regards

you need to change sequences

machine 1  sequences = 1, 3, 5, 7, 9

machine 2  sequences = 0, 2, 4, 6, 8


etc....


look for alter sequence, I use pgadmin3 to alter sequences.




-- 
------------

Itamar Reis Peixoto