[Pgpool-general] Database connection error occurred

[Tatsuo Ishii]

> 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