On Fri, Sep 11, 2009 at 7:07 PM, Tatsuo Ishii <[email protected]> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
