[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
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>
More information about the Bucardo-general
mailing list