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

[Tatsuo Ishii]

Hi Franklin,

> Hi Tatsuo Ishii,
> 
> Sorry for the delay in responding, below is pgpool.conf:

No problem.

> backend_flag1 = 'DISALLOW_TO_FAILOVER'
> backend_flag2 = 'DISALLOW_TO_FAILOVER'

These are the source of the issue. If DISALLOW_TO_FAILOVER is set,
pgpool tries to connect to the PostgreSQL and fails. The flag is
useful when PostgreSQL is managed by other systems so that the
PostgreSQL becomes online quickly. In other case, you should not use
the flag.

If the flag is not set, pgpool will disconnect the PostgreSQL in down
status and keep on operation with remaining PostgreSQL servers. After
the PostgreSQL comes back online again, you can let pgpool know that
by using pcp_attach_node.

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