Thread: Postgresql 9.1 logging
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: log_destination = 'syslog' logging_collector = on log_directory = 'pg_log' log_filename = 'postgresql-%a.log log_truncate_on_rotation = on log_rotation_age = 0 log_rotation_size = 0 syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on client_min_messages = log log_min_messages = warning log_min_error_statement = info log_min_duration_statement = 0 #debug_print_parse = off #debug_print_rewritten = off #debug_print_plan = off #debug_pretty_print = on log_checkpoints = on #log_connections = off #log_disconnections = off log_duration = off #log_error_verbosity = default #log_hostname = off log_line_prefix = 'user=%u,db=%d,host=%h ' #log_lock_waits = off log_statement = 'none' log_temp_files = 4096 #log_timezone = unknown
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 -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
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