I forgot to specify that this happens after, for example, backend_hostname0 is killed.
> -----Original Message----- > From: [email protected] [mailto:pgpool-general- > [email protected]] On Behalf Of Crespo, Daniel @ SDS > Sent: Friday, June 18, 2010 9:49 AM > To: Joe Conway; Tatsuo Ishii > Cc: [email protected] > 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: [email protected] [mailto:pgpool-general- > > [email protected]] On Behalf Of Joe Conway > > Sent: Thursday, June 17, 2010 8:40 PM > > To: Tatsuo Ishii > > Cc: [email protected] > > 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
