On Tue, May 13, 2014 at 10:47 PM, Juned Khan <[email protected]> wrote:
> On Thu, May 8, 2014 at 12:59 PM, Juned Khan <[email protected]> wrote: > >> DETAIL: Key (id)=(1) already exists. >> > You might try setting your sequences to be staggered (e.g., so that records inserted on db server 1 get odd-numbered values from the sequence, and records on db server 2 get even-numbered values). Look at the docs for the ALTER SEQUENCE statement, particularly the INCREMENT clause. Note, for that to work, you'd need *not* to be replicating the sequences, but only the tables. I believe the wiki has documentation describing this type of setup, though it may not be in the most obvious place any more. rls -- :wq
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
