Postgresql 9.1 logging - Mailing list pgsql-general

From Birta Levente
Subject Postgresql 9.1 logging
Date
Msg-id 4F045B1C.5010603@gmail.com
Whole thread Raw
Responses Re: Postgresql 9.1 logging  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Saurabh
Date:
Subject: Streaming replication with automatic failover?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Postgresql 9.1 logging