[pgpool-general: 7067] Re: What happens to active connections when failover happens?

[Rajni Baliyan]

Thanks for the advice Bo Peng.
Please close this request

On Mon, May 25, 2020 at 4:43 PM Bo Peng <pengbo at sraoss.co.jp> wrote:

> hello,
>
> On Fri, 22 May 2020 16:44:02 +1000
> Rajni Baliyan <saan654 at gmail.com> wrote:
>
> > sorry hit the wrong button and my question did not complete. Below is the
> > complete request-
> >
> >
> > > Hi pgpool experts,
> > > I have a question regarding pgpool connections.
> > >
> > > What will happen to user connections in below scenarios-
> > > - When request is being served on replica and replica went down.
> > >      - Will connection fail-over to other replica or master ?
> > >      - Will connection terminate and user has to start new session?
>
> The connection is terminated and user has to start a new session.
>
> > > - When actual failover is happening ?
>
> The actual failover occurs in the following three cases:
>
> (1) the primary server failure is detected by health checking
> (2) the queries fail on primary server
> (3) If watchdog is enable, the actual failover may be triggered by remote
> pgpool(watchdog)
>
> >
> > >
> > >
> > >
> > > Is there a good reference ( document/blog etc.)
> > >
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200604/576bcf8f/attachment.html>