[Bucardo-general] Problems syncing multiple databases

Greg Sabino Mullane greg at endpoint.com
Mon Jun 1 23:03:41 UTC 2015


On Mon, Jun 01, 2015 at 02:20:29PM -0600, John Jeffers wrote:
> bucardo add db db1_local dbame="DB1" addalltables addallsequences
> bucardo add db db1_remote dbname="DB1" pghost=rds.remote.host
> dbuser=username dbpass=password
> bucardo add dbgroup db1_dbgroup db1_local:source db1_remote:target
> bucardo add sync db1_sync tables=all dbs=db1_dbgroup autokick=0

The problem is we are a little too liberal in what we allow: the "add db" 
has the convenience of "addalltables" but no way to stick them into 
a named relgroup, which is what you want for the sync step. So try 
it this way, and make explicit relgroup and dbgroups for each sync:

bucardo add db db1_local dbname="DB1"
bucardo add db db1_remote dbname="DB1" pghost=rds.remote.host

bucardo add all tables db=db1_local relgroup=group1
bucardo add all sequences db=db1_local relgroup=group1

bucardo add dbgroup db1_dbgroup db1_local:source db1_remote:target
bucardo add sync db1_sync relgroup=group1 dbs=db1_dbgroup autokick=0

-- 
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/20150601/6151c265/attachment.sig>


More information about the Bucardo-general mailing list