[Bucardo-general] Problems syncing multiple databases

John Jeffers jjeffers at tendrilinc.com
Mon Jun 1 20:20:29 UTC 2015

Thanks for the reply. Here are the exact commands.

First, create DB1 on remote, then dump and restore *schema only* from
source to dest using pg_dump/pg_restore.

Next, run these commands:
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

Next, dump and restore *data only* from source to dest using

Finally, run:
bucardo update sync db1_sync autokick=1
bucardo start

When I try to run this same sequence of commands on DB2 and DB3, it fails
at the "add sync" step.

*John Jeffers |  *DevOps Engineer

2580 55th St.  |  Suite 100  |  Boulder, Colorado 80301
*P* 720.921.2249  |
<https://mail.google.com/mail/#14c76859fb1ddca0_SafeHtmlFilter_> *F*
Facebook <https://www.facebook.com/TendrilInc>  |  Twitter
<https://twitter.com/Tendril>  |  Blog
<http://www.tendrilinc.com/about-us/news-room/blog/>  |

On Mon, Jun 1, 2015 at 2:12 PM, Greg Sabino Mullane <greg at endpoint.com>

> On Mon, Jun 01, 2015 at 01:53:13PM -0600, John Jeffers wrote:
> > So, to get around this, I attempted to add a new relgroup for DB2.
> > However, there are tables with the same names in DB1 and DB2, so it also
> > fails when I try to create the relgroup.
> Cannot say for sure without seeing what exact commands you are trying,
> but if you want to add a table from a specific database, you can
> add the database to the end of the "add table" command like so:
> bucardo add table foobar db=DB2
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20150601/2f1c1fb6/attachment.html>

More information about the Bucardo-general mailing list