Hi, From: "Luis_Alberto_Pérez_Paz" <[EMAIL PROTECTED]> Subject: Re: [Pgpool-general] Health check Date: Wed, 12 Mar 2008 10:52:44 -0600
> My tests were with pgpool-3.4.1 and pgpool-II-1.3 > The same results in both. I've fixed into pgpool and pgpool-II 2.x. * pgpool-II 2.x http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/main.c.diff?r1=1.35&r2=1.36&f=u * pgpool http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool/main.c.diff?r1=1.24&r2=1.25&f=u > I didn't test with pgpool-II-2.0.1 because replicate_select does not work > and I need it. This was fixed in CVS HEAD. We are going to release pgpool-II 2.1 beta version on 17th Mar. Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] > > > My Postgresql is 8.3.0 > > Best Regards, > > > > On Tue, Mar 11, 2008 at 6:29 PM, Tatsuo Ishii <[EMAIL PROTECTED]> wrote: > > > What is your pgpool version? > > -- > > Tatsuo Ishii > > SRA OSS, Inc. Japan > > > > > Hi everybody, > > > > > > I'm doing a lot of tests with pgpool because we want to implement it in > > our > > > production environment. > > > > > > My laboratory is: > > > Computer 1: running pgpool > > > Computer 2: running postgres > > > Computer 3: running postgres > > > > > > I'm simulating a fall in one the psql servers (Computer 1 & 2). > > > > > > When I stop the postgres service, pgpool works great. My health_check > > > parameters are: > > > > > > health_check_timeout = 5 > > > health_check_period = 5 > > > > > > However when I unplugged the network cable (or even if I unplugged the > > power > > > cable) the health_check_timeout does not work, pgpool delays between 1 > > and 2 > > > minutes to detect the error. > > > > > > 2008-03-11 13:18:26 LOG: pid 23451: starting health checking > > > 2008-03-11 13:19:14 ERROR: pid 23451: connect_inet_domain_socket: > > connect() > > > failed: No route to host > > > > > > > > > Is it normal??? Can I detect these errors in another way? > > > > > > > > > Thanks in advance for your help. > > > > > > > > > Best Regards, > > > > > > > > > Luis Alberto Perez Paz > > > > > > -- > > > paz, amor y comprensión > > > (1967-1994) > > > > > > -- > paz, amor y comprensión > (1967-1994) _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
