Re: Postgresql 9.1 logging

On 04/01/2012 16:15, Andreas Kretschmer wrote:
> Birta Levente<blevi.linux@gmail.com>  wrote:
>
>> Hi all
>>
>> I use postgresql 9.1.2 on centos 6.2 and I want to use pgfouine, but in
>> my log file appear #011, #015 ... characters and the pgfouine can't
>> handle it.
>> Can I configure the server or rsyslog to log without these characters or
>> I need filter separately?
>>
>> thanks
>> Levi
>>
>> the log section from my configuration file:
> Set lc_message = 'C' in your postgresql.conf and restart/reload the server.
>
>
> Andreas
Thanks for your the reply, but nothing changed. When log to stderr these
characters not appear (even with lc_messages='en_US.utf8'), but pgfouine
recommend to use with syslog.
It's very simple to make a sed and work fine.... I am just curious to
know if it's possible.

Thanks anyway

Levi