[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