[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