In this case you should have some error messages in the PostgreSQL log. Can you show me them? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> sir thanks for your reply, > > for 1) i've created user "health_check_user" both primary and standby > instance, and i can able to login through psql (i.e psql -p 5432 -U > health_check_user -d template1) still i'm getting same result ( issue ) > listed earlier post. what else I've do ? > > for 2) kindly refer some link to set system DB setting > > one more issue 3) while click on recovery button it gives error message > pcp_recovery_node command error occurred and error code is e1012 > > solai > > On Wed, Jul 6, 2011 at 1:07 PM, Tatsuo Ishii <[email protected]> wrote: > >> > 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
