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

[Tatsuo Ishii]

> On Sun, Nov 20, 2011 at 4:27 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>>>> 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
> 
> The sample log entries look good to me, thanks!

Patch committed to master branch(to be 3.2).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp