[Bucardo-general] Trouble shooting db connections

Paul Tader ptader at spoton.com
Fri Sep 21 17:36:03 UTC 2018

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
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

$ bucardo list dbs
Database: qaec2  Status: active  Conn: psql -p 5432 -U migration -d mydb -h
Database: qards  Status: active  Conn: psql -p 5432 -U <snip>

$ psql -p 5432 -U migration -d mydb -h
psql (9.6.10, server 9.6.9)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384,
bits: 256, compression: off)
Type "help" for help.

spoton=# \q

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

More information about the Bucardo-general mailing list