<div dir="ltr">many thanks Tatsuo,<div><br></div><div>that fixed it and it is working as I'd expected! Great work on this product! </div><div><br></div><div>regards</div><div><br></div><div>Jeff McCormick</div></div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Mar 27, 2014 at 8:23 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can you please enable health checking? i.e.:<br>
health_check_period = 10<br>
Mime-Version: 1.0<br>
Content-Type: Text/Plain; charset=us-ascii<br>
Content-Transfer-Encoding: 7bit<br>
<br>
Can you please enable health check? (set non 0 to health_check_period)<br>
Otherwise pgpool does not notice that the standby node is not<br>
available anymore and keeps on connecting to the node without success.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div><div class="h5"><br>
> Hello,<br>
><br>
> I am trying to configure the most recent version of pgpool to<br>
> do load-balancing between a pg 9.3.2 master and standby<br>
> that are configured for streaming replication.<br>
><br>
> My configuration appears to load balance correctly across<br>
> the 2 nodes (master and standby) during normal operations.<br>
><br>
> However, when I shut down the standby node, the pgpool<br>
> will no longer work or allow connections to be made to<br>
> the master node which is still up.<br>
><br>
> The pgpool logs states the following:<br>
><br>
> 2014-03-27 18:54:04 ERROR: pid 17525: pool_read: EOF encountered with<br>
> backend<br>
> 2014-03-27 18:54:04 ERROR: pid 17525: s_do_auth: error while reading<br>
> message kind<br>
> 2014-03-27 18:54:04 ERROR: pid 17525: make_persistent_db_connection:<br>
> s_do_auth failed<br>
> 2014-03-27 18:54:04 ERROR: pid 17525: check_replication_time_lag: could not<br>
> connect to DB node 1, check sr_check_user and sr_check_password<br>
><br>
> pgpool defintely detects the shutdown of the standby node, but I would still<br>
> like to be able for it to allow connections to the master.<br>
><br>
> Is it possible for pgpool to allow connections to the master while the<br>
> standby is shutdown? I am probably missing some configuration option<br>
> and any help would be appreciated. Attached is my pgpool.conf<br>
><br>
> Jeff<br>
><br>
><br>
> --<br>
</div></div>> *Jeff McCormick*<br>
> <a href="tel:843-327-5754" value="+18433275754">843-327-5754</a><br>
> <a href="mailto:jeffmc04@gmail.com">jeffmc04@gmail.com</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><b>Jeff McCormick</b><div><font size="1">843-327-5754</font></div><div><font size="1"><a href="mailto:jeffmc04@gmail.com" target="_blank">jeffmc04@gmail.com</a></font></div>
</div>
</div>