[Bucardo-general] Alter tables

Greg Sabino Mullane greg at endpoint.com
Thu May 21 20:31:30 UTC 2015

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>

More information about the Bucardo-general mailing list