Postgresql 9.1 logging

From: Birta Levente <blevi(dot)linux(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql 9.1 logging
Date: 2012-01-04 13:58:52
Message-ID: 4F045B1C.5010603@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2012-01-04 14:15:16 Re: Postgresql 9.1 logging
Previous Message Saurabh 2012-01-04 10:47:38 Streaming replication with automatic failover?