[Pgpool-general] pgpool-II + pgpoolAdmin

[Tatsuo Ishii]

> 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
--
Tatsuo Ishii
SRA OSS, Inc. Japan