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



_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general

Reply via email to