>> 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 >> [email protected] >> 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
[email protected]
785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
