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

[Tatsuo Ishii]

>>> 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?
> 
> Good suggestion. I would like to include it for next release (3.2)
> unless someone beats me.

Here is the patch I promised. Here are sample log entries.

From TCP/IP client case:
2011-11-20 21:15:52 LOG:   pid 23045: SimpleQuery: Unable to parse the query: "select select;" from client 127.0.0.1(33737)

From Unix domain socket client case:
2011-11-20 21:14:46 LOG:   pid 23045: SimpleQuery: Unable to parse the query: "select select;" from local client

Comments?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: log_client.patch
Type: text/x-patch
Size: 2447 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111120/4dac5255/attachment.bin>