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
