[pgpool-general: 8647] Re: Clients disconnection when slave node is off

Tatsuo Ishii ishii at sraoss.co.jp
Thu Mar 16 20:42:43 JST 2023


> I have a problem with clients disconnection when the slave node is turn
> off.  It would be great if someone could help me with this issue.
> 
> 
> 
> My environment is:
> 
> 
> 
>    - OS: RHEL 5.7
>    - Postgres 11
>    - streaming replication as redundancy mode
>    - In one server runs pgpool and the primary database (node 0), in
>    another server runs the standby database (node 1).
>    - Load balance mode is disabled
>    - Both backend weight with default value
> 
> 
> I have a great number of clients connected to pgpool. The problem ocurrs
> when the slave node is stopped (because sometimes I need to power off the
> slave host). All clients are disconnected. Is there a way to avoid these
> disconnection?

In most cases client connections should not be disconnected when the
standby node goes down in this configuration. Can you share the pgpool
log when the standby goes down?

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



More information about the pgpool-general mailing list