[pgpool-general: 2200] Re: exclude postgresql errors from pgpool's log
Thomas SIMON
tsimon at neteven.com
Tue Oct 15 16:50:32 JST 2013
Arf, that's bad, espicially when you have a lot of errors :/
Thanks, anyway
Thomas
Le 15/10/2013 05:02, Tatsuo Ishii a écrit :
>> Hello everyone,
>>
>> I would like to exclude postgresql errors from pgpool's log, but I
>> can't find where to do this.
>> This error are already in postgresql.log, and i don't want to have
>> them twice, i would like only 'real' pgpool logs in my pgpool.log (i
>> have redirected logs from syslog to a particular file).
>>
>> Is this possible to do this ?
> Currently, no.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>> Here an extract from my pgpool.conf file
>>
>> #------------------------------------------------------------------------------
>>
>> # LOGS
>> #------------------------------------------------------------------------------
>>
>>
>> # - Where to log -
>>
>> log_destination = 'syslog'
>> # Where to log
>> # Valid values are combinations of stderr,
>> # and syslog. Default to stderr.
>>
>> # - What to log -
>>
>> print_timestamp = on
>> # Print timestamp on each line
>> # (change requires restart)
>>
>> log_connections = on
>> # Log connections
>> log_hostname = on
>> # Hostname will be shown in ps status
>> # and in logs if connections are logged
>> log_statement = off
>> # Log all statements
>> log_per_node_statement = off
>> # Log all statements
>> # with node and backend informations
>> log_standby_delay = 'none'
>> # Log standby delay
>> # Valid values are combinations of always,
>> # if_over_threshold, none
>>
>> # - Syslog specific -
>>
>> syslog_facility = 'LOCAL0'
>> # Syslog local facility. Default to LOCAL0
>> syslog_ident = 'pgpool'
>> # Syslog program identification string
>> # Default to 'pgpool'
>>
>> # - Debug -
>>
>> debug_level = 0
>> # Debug message verbosity level
>> # 0 means no message, 1 or more mean verbose
>>
>> Thanks,
>> Thomas
More information about the pgpool-general
mailing list