Postgresql 9.1 logging
От | Birta Levente |
---|---|
Тема | Postgresql 9.1 logging |
Дата | |
Msg-id | 4F045B1C.5010603@gmail.com обсуждение исходный текст |
Ответы |
Re: Postgresql 9.1 logging
|
Список | 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 по дате отправления: