[Bucardo-general] Add new master to existing sync

Greg Sabino Mullane greg at endpoint.com
Wed Feb 25 18:46:14 UTC 2015


On Tue, Feb 24, 2015 at 11:04:18AM +0100, Laurent GARCES wrote:
> Hi,
> 
> We would like to be able to add new database source to existing sync.
> Here is what we for now that does not work:
> 
> bucardo add db db dbname=... host=... user=... password=...
> bucardo add db db1 dbname=... host=... user=... password=...
> bucardo add sync sync dbs=db:source,db1:source tables=all
> (This is OK)
> Then we thougth we should do something like this:
> bucardo add db db2 dbname=... host=... user=... password=...
> bucardo uppdate sync sync dbs=db:source,db1:source,db2=source tables=all

update sync doesn't have a lot of brains. What you have to do is change 
the underlying dbgroup that the sync uses. You can find the name of it 
by doing:

bucardo list sync syncname

It will probably be the same name as the sync itself. Then you can modify it 
and tell it all the databases and their roles that should be in it. For 
the example above, you would do:

bucardo update dbgroup foobar db:source db1:source db2:source

Documentation and functionality-improving patches welcome. :)

-- 
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/20150225/916c6d9b/attachment.sig>


More information about the Bucardo-general mailing list