[Pgpool-general] Database connection error occurred

[Tatsuo Ishii]

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 <ishii at sraoss.co.jp> 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
>>