[pgpool-general: 2197] Re: exclude postgresql errors from pgpool's log

Tatsuo Ishii ishii at postgresql.org
Tue Oct 15 12:02:40 JST 2013


> 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