[Bucardo-general] Trouble shooting db connections

[David Christensen]

>> Sorry, that would be Postgres’ “log_min_messages” parameter, and it will show up in the PostgreSQL log file. You could probably just change on the validate_goat function via running the following in your “bucardo” database:
>> 
>> ALTER FUNCTION bucardo.validate_goat() SET log_min_messages = ‘DEBUG’;
>> 
>> (Hand-waving syntax here; if you want to just change globally you can as well, it’ll just introduce a lot more noise.)
>> 
>> --
>> David Christensen
>> End Point Corporation
>> david at endpoint.com
>> 785-727-1171
>> 
>> 
> Unfortunately, because the disk containing the WAL files filled up, the database shutdown and I had to restart the bucardo process and the original problem is back, adding a sync fails but psql connections from the command line succeed.
> 
> $ bucardo add sync mysync tables=all dbs=qasync --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.
> 
> 
> I did set:
> 
>  ALTER FUNCTION bucardo.validate_goat() SET log_min_messages = ‘DEBUG’;
> 
> …but the postgres logs echo the same error.


So you are seeing nothing from this line in the postgres logs?:

elog(DEBUG, "Connecting in validate_goat as $db{dsn} user=$db{user} pid=$$ for table $schema.$table");
--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20181001/00bf09b3/attachment.sig>