[Pgpool-general] pgpool-II + pgpoolAdmin
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Dec 4 02:38:22 UTC 2007
> 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
More information about the Pgpool-general
mailing list