[Bucardo-general] Trouble shooting db connections
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 "126.96.36.199" 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 188.8.131.52
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general