[pgpool-general: 8933] Re: Offline replica and pgpool do not respond or connect with psql

[Tatsuo Ishii]

> Hello everyone,
> 
> I'm using pgpool, a master and two replicas, but when a replica goes
> down, pgpool no longer responds. I can't connect with psql and in the
> log I have the following:
> 
> LOG: failed to connect to PostgreSQL server on "ip_address:5432"
> 
> The application becomes inoperative. Is there a way to make pgpool
> more resilient in relation to this?

In a standard setting of pgpool, it automatically disconnects the
replica which went down and continues to provide service to clients
like psql.

It seems there's something wrong/unusual in your configuration. To
study the issue further, the version of pgpool, pgpool.log while the
replica went down and pgpool.conf are needed (you can mask items which
you do not want to put in public in those files).

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp