Re: [Pgpool-general] rawmode failover

2010-06-18 Thread Daniel . Crespo
. Daniel -Original Message- From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general- boun...@pgfoundry.org] On Behalf Of Joe Conway Sent: Thursday, June 17, 2010 8:40 PM To: Tatsuo Ishii Cc: pgpool-general@pgfoundry.org Subject: Re: [Pgpool-general] rawmode failover * PGP

Re: [Pgpool-general] rawmode failover

2010-06-18 Thread Daniel . Crespo
; Tatsuo Ishii Cc: pgpool-general@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

Re: [Pgpool-general] rawmode failover

2010-06-18 Thread Joe Conway
-boun...@pgfoundry.org [mailto:pgpool-general- boun...@pgfoundry.org] On Behalf Of Crespo, Daniel @ SDS Sent: Friday, June 18, 2010 9:49 AM To: Joe Conway; Tatsuo Ishii Cc: pgpool-general@pgfoundry.org Subject: Re: [Pgpool-general] rawmode failover I have health check enabled every 5 seconds

[Pgpool-general] rawmode failover

2010-06-17 Thread Joe Conway
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

Re: [Pgpool-general] rawmode failover

2010-06-17 Thread Tatsuo Ishii
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

Re: [Pgpool-general] rawmode failover

2010-06-17 Thread Joe Conway
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