[Bucardo-general] How does bucardo administrate autoincrement values ?
hiramwalker at gmail.com
Wed Dec 13 16:17:43 UTC 2017
Thanks Greg, have a nice day,
Hiram Walker O.
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...
More information about the Bucardo-general