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

[Aleksey Tsalolikhin]

On Fri, Sep 11, 2009 at 7:07 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> Hi.  pgpool-II v2.2.4 has failed out my PostgreSQL 8.3.7 database.
>>
>> How can I tell why?
>
> In this case you should find error logs in your pgpool log. Can you
> show us them?

Dear Tatsuo,

  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'
#


But there is no pgpool log file in /var/log/pgpool:


# ls -l /var/log/pgpool
total 8
-rw-r--r-- 1 root root 132 Sep 11 15:02 failover
# cat /var/log/pgpool/failover
ddc-db-prod01 5432 /usr/local/pgsql/data/ 0
ddc-db-prod01 5432 /usr/local/pgsql/data/ 0
ddc-db-prod01 5432 /usr/local/pgsql/data/ 0
#


Why is there no pgpool log, please?

Best,
Aleksey