[Bucardo-general] How does bucardo administrate autoincrement values ?

[Hiram Walker]

Thanks Greg, have a nice day,

Regards,
Hiram

Saludos cordiales,

Hiram Walker O.
+56965824408



2017-12-12 18:39 GMT-03:00 Greg Sabino Mullane <greg at endpoint.com>:

> Sory, been to busy to reply but I can do this one super quick:
>
> > ERROR: duplicated key
> ..
> > How can I tell bucardo that I have a column With Autoincrement value?
>
> You cannot. The canonical solution is to adjust the sequences on both
> ends such that they cannot collide.
>
> Server A: ALTER SEQUENCE foo_id_seq RESTART WITH 10000 INCREMENT BY 2;
>
> Server B: ALTER SEQUENCE foo_id_seq RESTART WITH 10001 INCREMENT BY 2;
>
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20171213/84adccf0/attachment.html>