[pgpool-general: 2981] Re: health check failed
nagata at sraoss.co.jp
Fri Jun 27 15:25:09 JST 2014
On Thu, 26 Jun 2014 14:15:17 +0000
Wolf Schwurack <wolf at uen.org> wrote:
> Yes the backend is working? The application is able to connect.
> I set in /etc/hosts postgres servers IP and hostname on the pgpool servers
> and on postgres servers I set pgpool IP and hostname in /etc/hosts. its
> all on the same network so there should be any network issues.
> It doesn¹t go through a firewall
> Here shows the connection from pgpool to postgres
> pgprod-con1 ~ pgpool $ psql -p 9999
> psql (9.2.6)
> Type "help" for help.
> Show nodes
> postgres=# show pool_nodes;
> node_id | hostname | port | status | lb_weight | role
> 0 | pgprod-db | 5432 | 2 | 0.500000 | primary
> 1 | pgprod-rep | 5432 | 2 | 0.500000 | standby
> (2 rows)
> I¹m not getting the error in my dev environment and in my RC environment I
> only see the error on my standby pgpool server.
If there is no network problem betwenn standby pgoool and backends,
this might be authentication problem like pg_hba.conf configuration.
Can you see any error in pgpool.log like
ERROR: make_persistent_db_connection: s_do_auth failed
or other errors in backend postgres's log?
> Our setup for all of our environments
> 2 pgpool servers (primary/standby)
> 2 postgres server (primary with streaming standby)
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> Wolf at uen.org
> On 6/25/14, 9:04 PM, "Yugo Nagata" <nagata at sraoss.co.jp> wrote:
> >Please confirm the below;
> >- The backend is actually working? Hostname and port number are right?
> >- The network between pgpool and postgres is healty?
> > Can you connect postgres from pgpool server by psql command?
> >- Firewall configuration is right? SELinx etc. might cause.
> >If all is ok, pgpool configuration might be wrong. Could you please
> >send all pgpool log and pgpool.conf?
> >On Wed, 25 Jun 2014 13:39:30 +0000
> >Wolf Schwurack <wolf at uen.org> wrote:
> >> I keep getting this error in my pgpool.log file
> >> ERROR: pid 1250: health check failed. 0 th host pgprod-db at port 5432
> >>is down
> >> Servers: Ubuntu 10.04.4 LTS
> >> Postgres: psql (9.2.6)
> >> Pgpool: pgpool-II version 3.3.3 (tokakiboshi)
> >> Wolfgang Schwurack
> >> Database/System Administrator
> >> Utah Education Network
> >> 801-587-9444
> >> Wolf at uen.org
> >Yugo Nagata <nagata at sraoss.co.jp>
Yugo Nagata <nagata at sraoss.co.jp>
More information about the pgpool-general