[Bucardo-general] bucardo replication not happening

Greg Sabino Mullane greg at endpoint.com
Tue Dec 9 18:00:10 UTC 2014


> * bucardo add db dbprod host=$rds_host user=bucardo pass=bucardo
> dbname=database_A
> * bucardo add db dblocal dbname=database_A
> * bucardo add table some_schema.foo relgroup=test_grp db=dbprod
> * bucardo add sync test_sync relgroup=test_grp dbs=dblocal

You need to tell the sync which databases are involved. Right now there 
is only one, "dblocal". If you want to replicate from dblocal to 
dbprod you should try:

bucardo add sync test_sync relgroup=test_grp dbs=dblocal,dbprod

There is an implicit setting of the first database to be a source, 
and the second to be a target, so the above is equivalent to:

bucardo add sync test_sync relgroup=test_grp dbs=dblocal:source,dbprod:target


-- 
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/20141209/0b37887d/attachment.sig>


More information about the Bucardo-general mailing list