[Pgpool-general] logging the client IP address/hostname

Lonni J Friedman netllama at gmail.com
Mon Nov 7 00:38:48 UTC 2011


Greetings,
I'm using pgpool-3.0.4 to load balance queries between 3 PostgreSQL
servers.  I'm occasionally seeing some "unable to parse the query'
errors in the pgpool log for queries that are malformed from a client.
 The problem is that pgpool doesn't log the client IP or hostname, so
its rather difficult to debug.  Other than enabling full debug logs
for pgpool, is there some way to add the client IP address (or
hostname) whenever pgpool creates a log entry?

thanks!


More information about the Pgpool-general mailing list