[Pgpool-general] rawmode failover

[Daniel.Crespo at l-3com.com]

I forgot to specify that this happens after, for example,
backend_hostname0 is killed.

> -----Original Message-----
> From: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> bounces at pgfoundry.org] On Behalf Of Crespo, Daniel @ SDS
> Sent: Friday, June 18, 2010 9:49 AM
> To: Joe Conway; Tatsuo Ishii
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] rawmode failover
> 
> I have health check enabled every 5 seconds or so, but most of the
time
> (if not always) I experience a failed attempt to connect (or execute a
> query in an already started session), then, the next attempt succeeds.
> So I think it is not working for me for avoiding the connection
attempt
> failure.
> 
> Daniel
> 
> > -----Original Message-----
> > From: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> > bounces at pgfoundry.org] On Behalf Of Joe Conway
> > Sent: Thursday, June 17, 2010 8:40 PM
> > To: Tatsuo Ishii
> > Cc: pgpool-general at pgfoundry.org
> > Subject: Re: [Pgpool-general] rawmode failover
> >
> > * PGP Signed by an unknown key
> >
> > On 06/17/2010 05:39 PM, Tatsuo Ishii wrote:
> > >> In rawmode, set up for failover per the docs, I find that after
> > >> killing backend_hostname0, my first attempt to access the
database
> > >> via pgpool will fail, and the second attempt will succeed against
> > >> backend_hostname1. Is this normal? I.e. is there a way to
> eliminate
> > >> the initial failed connection after backend_hostname0 goes down?
> > >
> > > Enabling health checking should help you. If the health checking
> find
> > > backend goes down, it will trigger failover immediately, rather
> than
> > > "first attempt to access the database via pgpool". So next attempt
> to
> > > connect pgpool will success.
> >
> > Ah, OK -- thanks!
> >
> > Joe
> >
> >
> >
> > * Unknown Key
> > * 0x35F7D865
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general