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

Tatsuo Ishii ishii at postgresql.org
Fri Mar 28 09:23:38 JST 2014


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


More information about the pgpool-general mailing list