[Bucardo-general] Replication problems? data overwritten?

[Joshua Tolley]

On Fri, Aug 23, 2013 at 04:27:52PM +0000, eric machine wrote:
>    a) If I change the sequence in postgres just like that, will that
>    normally affect the overall database design from the open source
>    system? I mean will it crash the system?

It's awfully unlikely that it would.

>    b) And when you do this?
>    CREATE SEQUENCE some_id_seq INCREMENT BY 2;
>    Will that sequence reflects to all tables automatically? Or just
>    specific table?

The sequence in question most likely underlies only one primary key, so you'll
probably have to find all the sequences for all of the tables you want to
replicate, and modify each one.

>    c) If I follow your approach on updating the sequences, do I still run
>    this command?
>    bucardo add all sequences herd=therd

No, you don't want Bucardo setting the current value on these sequences for
you.

>    d) Lastly, for this command
>    SELECT setval('some_id_seq'::regclass, 104);
>    I assume I run this only once right?

Right.

>    However for new database from fresh, I can just ignore this. Correct?

If you've set the sequences in one database to start with an even number when
you created it, you don't need to set the value separately. You do that this
way:

    CREATE SEQUENCE whatever ... START WITH 2

>    e) Can bucardo do streaming replication? I mean always sync when
>    there's data changes?

Bucardo tries to replicate each time a sync is "kicked", which by default
happens every few seconds. You can turn on "autokick" to get it to kick the
sync every time something changes.

-- 
Josh Tolley   josh at endpoint.com   801-987-0252
End Point Corporation  http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130823/4adfeefc/attachment-0001.sig>