[Bucardo-general] Trouble shooting db connections

Paul Tader ptader at spoton.com
Fri Sep 21 18:45:56 UTC 2018

On Sep 21, 2018, 1:28 PM -0500, David Christensen <david at endpoint.com>, wrote:
> > On Sep 21, 2018, at 12:36 PM, Paul Tader <ptader at spoton.com> 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=;port=5432','migration',...) failed: could not connect to server: Connection timed out
> > Is the server running on host "" 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
> david at endpoint.com
> 785-727-1171
Sorry, I should have clarified. Yes, the bucardo database, daemon and commands are all run from a “admin” node. Connections from the admin node to the two database I want to be apart of the sync are successful. I also checked the connection to the local (bucardo) database and it was fine.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180921/b52c487c/attachment.html>

More information about the Bucardo-general mailing list