[Bucardo-general] PostgreSQL/Bucardo Sequences

Chris Keane chris.keane at zoomius.com
Sun Nov 9 18:50:45 UTC 2014

In our case where we have a LOT of masters, we use bigserial sequences (so
they use bigints instead of ints).
Each server gets its own "prefix" and each "prefix" is unique. For example,
the server I'm looking at right now is server #25, because its sequences
all have min_value 2500000000000001 and max_value 2599999999999999 and
start_value of 2500000000000001

That way we can support many servers and can tell at a glance which one
generated a particular record.


On Sun, Nov 9, 2014 at 10:31 AM, Greg Sabino Mullane <greg at endpoint.com>

> On Sun, Nov 09, 2014 at 04:02:01PM +0000, Adeyinka wrote:
> >
> > Do I have to run this commands for each sequence? I have quite
> > a number. Or is there a wildcard I could use.
> No, you will need to do that for every sequence in each table you
> are replicating.
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general

*Chris Keane* * Track Intelligence Inc *  +1 (650) 703 5523 (cell)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20141109/f54c778c/attachment.html>

More information about the Bucardo-general mailing list