[pgpool-general: 2188] Re: query logging with usernames?

[Tatsuo Ishii]

Graham,

Yes, I would like to do so for pgpool-II 3.4.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Tatsuo,
> 
> Thanks for your response -- if this functionality could be added I think
> it could be quite useful.  Do you think it's possible that it might be
> available in the next release?
> 
> Best,
> Graham
> 
>> Hello,
>>
>> I'm fairly new to pgpool, and I realize that I'm probably using it
>> differently than most people do -- I'm interested in using it for logging
>> and compliance purposes.
>>
>> I know that PostgreSQL makes it possible to log queries with usernames.
>> Is it possible to do this with pgpool?  As far as I can tell, it's
>> possible to log connections by username, but not individual queries.  Any
>> advice would be appreciated.
> 
> Currently no. It's fairly easy to add that functionality however. The
> reason why it has not existed until today is, just nobody requested
> it.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>