[Pgpool-general] rawmode failover

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

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