[Bucardo-general] modifying a table in bucardo, including PK

[Markova, Nina]

Hi all,

I have a table TABLE1  that is being replicated in bucardo.
I need to change the table structure -  will add more fields, some of which will be part of PK (i.e. PK will change too).

What is the best approach doing that? I wasn't able to find a blog for that.


? stop bucardo
1) remove TABLE1 from db, herd, sync
2) modify TABLE1 (incl.PK) - alter table ...command
3) add modified TABLE1 to bucardo in db, herd, sync
4) validate sync, start bucardo

Any caveats ?

Thanks,
Nina



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140411/78f437e8/attachment.html>