[pgpool-general: 2673] Re: help with load balancing configuration

[jeff mccormick]

many thanks Tatsuo,

that fixed it and it is working as I'd expected!  Great work on this
product!

regards

Jeff McCormick


On Thu, Mar 27, 2014 at 8:23 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Can you please enable health checking? i.e.:
> health_check_period = 10
> Mime-Version: 1.0
> Content-Type: Text/Plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Can you please enable health check? (set non 0 to health_check_period)
> Otherwise pgpool does not notice that the standby node is not
> available anymore and keeps on connecting to the node without success.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > Hello,
> >
> > I am trying to configure the most recent version of pgpool to
> > do load-balancing between a pg 9.3.2 master and standby
> > that are configured for streaming replication.
> >
> > My configuration appears to load balance correctly across
> > the 2 nodes (master and standby) during normal operations.
> >
> > However, when I shut down the standby node, the pgpool
> > will no longer work or allow connections to be made to
> > the master node which is still up.
> >
> > The pgpool logs states the following:
> >
> > 2014-03-27 18:54:04 ERROR: pid 17525: pool_read: EOF encountered with
> > backend
> > 2014-03-27 18:54:04 ERROR: pid 17525: s_do_auth: error while reading
> > message kind
> > 2014-03-27 18:54:04 ERROR: pid 17525: make_persistent_db_connection:
> > s_do_auth failed
> > 2014-03-27 18:54:04 ERROR: pid 17525: check_replication_time_lag: could
> not
> > connect to DB node 1, check sr_check_user and sr_check_password
> >
> > pgpool defintely detects the shutdown of the standby node, but I would
> still
> > like to be able for it to allow connections to the master.
> >
> > Is it possible for pgpool to allow connections to the master while the
> > standby is shutdown?  I am probably missing some configuration option
> > and any help would be appreciated.  Attached is my pgpool.conf
> >
> > Jeff
> >
> >
> > --
> > *Jeff McCormick*
> > 843-327-5754
> > jeffmc04 at gmail.com
>



-- 
*Jeff McCormick*
843-327-5754
jeffmc04 at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140328/ccca0f56/attachment.html>