On Sun, Nov 6, 2011 at 5:58 PM, Tatsuo Ishii <[email protected]> wrote: >> 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? > > By enabling "log_connections" you have your client IP and pgpool child > pid in your log. Since the log for "unable parse..." includes pgpool > child pid, you can get client IP by checking pgpool child pid. > > LOG: pid 4327: connection received: host=[local] > LOG: pid 4327: SimpleQuery: Unable to parse the query: select select;
I was hoping there was some way other than enabling log_connections, as that's going to log every single connection (millions/day), even if there's no error? _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
