[Pgpool-general] Replication health check failed on 2nd node
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Sep 28 23:19:55 UTC 2010
> When I started the pgpool2 (version 3.0 on CentOS, with user
> 'sd3ops1', not 'postgres') on a host different from the two db hosts,
> I noticed that the log always failed on health_check on node 1 db with
> the following message (without any client connection yet):
>
> health_check: 0 th DB node status:1
> health_check: 1 th DB node status:3
>
> I tried to switch the db hosts and still got the same results. I also
> tried manually without problem to connect to each db. Any solution
> and/or suggestion on how to resolve the problem ?
Maybe health_check_user is not appropreate or pg_hba.conf on the 1th DB
does not accept connection from pgpool-II.
What does it show if you run psql on the host where pgpool-II is running:
psql -U (the username you specfied for health_check_user) -h (the host you have problem with) template1
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
More information about the Pgpool-general
mailing list