I have install pgpool 3.1.0 alpha 1 version. Here is pgpoolAdmin log 2010-11-19 06:42:14 ERROR: pid 8813: pool_init_pool_passwd: couldn't open /usr/local/etc/pool_passwd. reason: Permission denied 2010-11-19 06:42:14 LOG: pid 8813: Backend status file /var/log/pgpool/pgpool_status discarded 2010-11-19 06:42:14 LOG: pid 8813: pgpool-II successfully started. version 3.1.0-alpha1 (umiyameboshi) 2010-11-19 06:42:14 ERROR: pid 8847: connect_inet_domain_socket: connect() failed: Connection refused 2010-11-19 06:42:14 ERROR: pid 8847: make_persistent_db_connection: connection to localhost(5433) failed 2010-11-19 06:42:14 LOG: pid 8813: find_primary_node: primary node id is 0 2010-11-19 06:42:14 ERROR: pid 8813: connect_inet_domain_socket: connect() failed: Connection refused 2010-11-19 06:42:14 ERROR: pid 8813: health check failed. 1 th host localhost at port 5433 is down 2010-11-19 06:42:14 LOG: pid 8813: set 1 th backend down status 2010-11-19 06:42:14 LOG: pid 8813: starting degeneration. shutdown host localhost(5433) 2010-11-19 06:42:14 LOG: pid 8813: execute command: /usr/local/etc/failover.sh 1 "localhost" 5433 /opt/PostgreSQL/9.0/data_5433 0 0 "localhost" 0 2010-11-19 06:42:14 LOG: pid 8813: failover_handler: set new master node: 0
2010-11-19 06:42:14 LOG: pid 8813: failover done. shutdown host localhost(5433) 2010-11-19 06:42:14 LOG: pid 8813: find_primary_node: primary node id is 0 On Fri, Nov 19, 2010 at 11:58 AM, tuanhoanganh <[email protected]> wrote: > I was follow website > http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html > But when i click Node Info nothing display, click to Summary, Process Info, > Log work well. > > This is pgpoolAdmin log > 2010-11-19 05:48:20 ERROR: pid 2779: pool_init_pool_passwd: couldn't open > /usr/local/etc/pool_passwd. reason: Permission denied > 2010-11-19 05:48:20 LOG: pid 2779: Backend status file > /var/log/pgpool/pgpool_status discarded > 2010-11-19 05:48:20 LOG: pid 2779: pgpool-II successfully started. > version 3.0.1 (umiyameboshi) > 2010-11-19 05:48:21 ERROR: pid 2779: connect_inet_domain_socket: > connect() failed: Connection refused > 2010-11-19 05:48:21 ERROR: pid 2779: health check failed. 1 th host > localhost at port 5433 is down > 2010-11-19 05:48:21 LOG: pid 2779: set 1 th backend down status > 2010-11-19 05:48:21 LOG: pid 2779: starting degeneration. shutdown host > localhost(5433) > 2010-11-19 05:48:21 LOG: pid 2779: execute command: > /usr/local/etc/failover.sh 1 "localhost" 5433 /opt/PostgreSQL/9.0/data_5433 > 0 0 "localhost" > [: 24: =: argument expected > > 2010-11-19 05:48:21 LOG: pid 2779: failover_handler: set new master node: > 0 > 2010-11-19 05:48:21 LOG: pid 2779: failover done. shutdown host > localhost(5433) > And psql -p 9999 -U postgres work well > > How to fix it > > Thanks in advance > Tuan Hoang Anh >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
