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 [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
