[Bucardo-general] Alter tables

[Greg Sabino Mullane]

On Tue, May 19, 2015 at 12:24:29PM +0200, Laurent GARCES wrote:
> Hi,
> 
> We have two postgresql production servers with master to master
> bucardo replication and need to add some fields to some tables.
> Is it possible to update the bucardo schema so that it will
> replicate the new fields without stopping the replication process at
> anytime?
> For now the only process we have successfully done in this case is
> to stop bucardo, drop the bucardo schema and recreate the syncs
> "from scratch". We hope that there is a smarter solution...

You should be able to make the changes and then tell Bucardo to 
reload the sync:

$ bucardo reload sync foobar

You may see some errors if a sync starts up after you ALTER and before the 
sync reloads, but as long as the changes do not involve the primary keys, 
it should work.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150521/317ca89f/attachment.sig>