[Pgpool-general] pgpool-II failed out my database - why?

[Tatsuo Ishii]

>   I don't seem to have a pgpool log.  The only thing I have in my
> "logdir" is the failover log.
> 
> # ps -ef|grep pgpool.conf
> root      3030     1  0 Sep11 ?        00:00:00 /usr/local/bin/pgpool
> -f /etc/pgpool.conf -a /etc/pool_hba.conf -n -d
> root     17492 17460  0 12:09 pts/9    00:00:00 grep pgpool.conf
> # grep log /etc/pgpool.conf
> logdir = '/var/log/pgpool'
> # If true print timestamp on each log line.
> failover_command = 'echo %h %p %D %d >> /var/log/pgpool/failover; echo
> "pgpool failover event:  %h %p %D %d " | mail -s "pgpool failover
> event:  %h %p %D %d " root,ddcsw'
> failback_command = 'echo %h %p %D %d >> /var/log/pgpool/failback; echo
> "pgpool failback event:  %h %p %D %d " | mail -s "pgpool failback
> event:  %h %p %D %d " root,ddcsw'
> # If true, print all statements to the log.  Like the log_statement option
> log_statement = true
> # If true, incoming connections will be printed to the log.
> log_connections = true
> # connection log if log_connections = true.
> log_hostname = false
> # system_db_schema = 'pgpool_catalog'

Please redirect pgpool-II output to whatever logfile you like. For
example,

/usr/local/bin/pgpool -f /etc/pgpool.conf -a /etc/pool_hba.conf -n -d > /var/log/pgpool/pgpool.log 2>&1
--
Tatsuo Ishii
SRA OSS, Inc. Japan