[pgpool-general: 8649] Re: Clients disconnection when slave node is off
Jesús Campoy
jesuscampoy at gmail.com
Fri Mar 17 05:38:55 JST 2023
Ok, I will send you the log ASAP.
I forget to indicate that we are running two instances of pgpool using
watchdog and VIP.
I mean, in host A is running pgpool (active) and primary database. In host
B is running the other instance of pgpool and the standby database.
Sometimes I have to power off the host B and then, the clients connected to
pgpool in VIP are disconnected.
I have the same pgpool.conf for both pgpool instances. Do you need It?
Thanks for your help!
Best,
Jesús
El jue, 16 mar 2023 12:42, Tatsuo Ishii <ishii at sraoss.co.jp> escribió:
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230316/ac09c8be/attachment.htm>
More information about the pgpool-general
mailing list