[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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp