[Bucardo-general] Trouble shooting db connections

[Paul Tader]

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.

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

$ psql -p 5432 -U migration -d mydb -h 123.123.123.123
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>