> On Sep 21, 2018, at 12:36 PM, Paul Tader <[email protected]> wrote: > > Is there a way to troubleshoot why the "add sync" command fails? > > This is the second sync I've run from this host between a different set of > hosts (DEV and QA environments). The hosts have been added and a psql > connection from the command line works fine but when I try to setup a sync it > connections to one of the databases times out. > > $ bucardo add sync qasync tables=all dbs=qadbs --verbose > DBD::Pg::st execute failed: ERROR: DBI > connect('dbname=mydb;host=123.123.123.123;port=5432','migration',...) failed: > could not connect to server: Connection timed out > Is the server running on host "123.123.123.123" and accepting > TCP/IP connections on port 5432? at line 63. > CONTEXT: PL/Perl function "validate_goat" at /usr/local/bin/bucardo line > 5209.
Hi Paul, Is the “bucardo” database running on a different server as the Bucardo daemon? Some database connections are made from the server that the Bucardo daemon runs on and some are made directly from the database in plperl functions, so I suspect the “bucardo” database is the piece having connection issues, potentially due to firewalls or other access. If you can run a test psql connection from the database server itself then that may help in debugging this issue. Best, David -- David Christensen End Point Corporation [email protected] 785-727-1171 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
