[Pgpool-general] pgpool-II + pgpoolAdmin

[建維]

>> HI, ALL
>>     I am using pgpool-II-2.0.1 + pgpoolAdmin-2.0.0-beta1.
>>     Test on load-balance + replication mode.
>>     pgpoolAdmin 2.0 Summary as follows.
>> Summary
>> Parallel Mode            pgpool-I
>> Query Cache            Off
>> Replication Mode     On
>> Load Balance Mode On
>> Health Check            On
>> 
>>     Node info as follows.
>> Node Info.
>> IP Address     Port           Status       Weight
>> 192.168.0.82 5432 Up. Connected 0.250
>> 192.168.0.92 5433 Up. Connected 0.250
>> 192.168.0.81 5432 Up. Connected 0.250
>> 192.168.0.81 5433 Up. Connected 0.250
>> 
>>     But in second option. Node Status page. Status always show "Down"
>> Node Status
>>   IP Address   Port   Status
>> 192.168.0.82 5432 Down
>> 192.168.0.82 5433 Down
>> 192.168.0.81 5432 Down
>> 192.168.0.81 5433 Down
>> 
>>     Which part that I miss config? Can anyone help me?
> 
> To show the node status, pgpoolAdmin sends connect requests to each
> PostgreSQL server. My wild guess is, the user pgpoolAdmin uses to
> connect to PostgreSQL is not a valid PostgreSQL user.
> 
> Don't you find following log or some such in the PostreSQL log?
> 
> FATAL:  role "aaa" does not exist

Yes, I found this log....

FATAL:  role "nobody" does not exist

So, I modify pgpool.conf.
set health_check_user = 'postgres'

The status show 'Up" now.
Thank you very much

Jerry

> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>