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

[Tatsuo Ishii]

Glad to hear that!

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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