> i;ve successfully installed pgpool-ii, i have few issue listing below kindly > help me out. > 1 ) in pgpooladmin while i'm clicking on node status its shows > IP Address Port Status > 127.0.0.1 5432 Down > 127.0.0.1 5434 Down > but two db instance running successfully, i can able to login using psql. > also i checked using pcp_node_info command > ./pcp_node_info 0 localhost 9898 postgres postgres 0 - output is > 127.0.0.1 5432 1 0.500000 (my case status is 1 is it ok?)
pgpoolAdmin status checking above does not use pcp command. Rather, it directly connects to PostgreSQL with: user = health_check_user database = template1 So you should allow the user to connect to the database. > 2) while clicking on query cache/partition rule it is showing Error Message > Database connection error occurred. error caode e2001 and e3001, what could i > do > to solve the above issue's That requires system db is set properly. Please check related settings. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
