<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
After reading a post from Tatsuo Ishii:<br>
<pre wrap="">(health_check_timeout + health_check_retry_delay) * health_check_max_retries = (10+1)*3 = 44 seconds.
I realizezd I had health_check_max_retries = 0 and changing that seemed to fix my problem.
I don't really understand why this made my %H the ip of the old master or why it changed my directory path but it's working now.
Thanks for your help.
</pre>
<div class="moz-cite-prefix">On 01/19/2018 08:34 AM, chris wrote:<br>
</div>
<blockquote type="cite"
cite="mid:898b81c2-c01f-b984-72b9-36d1aa82814c@pgsqlrocket.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Thank you for responding to my post. I do understand what
you're saying, that's why I don't understand why I'm getting the
old master node when I use %H, backend0 is ...0 backend1 is
...1. When I test the failover I'm getting: <br>
</p>
<pre wrap="">ssh -T <a class="moz-txt-link-abbreviated" href="mailto:postgres@10.16.0.121" moz-do-not-send="true">postgres@...0</a> /usr/pgsql-9.5/bin/pg_ctl -D
/var/lib/pgsql/9.6/data promote
when instead I want it to be:
</pre>
<pre wrap="">ssh -T <a class="moz-txt-link-abbreviated" href="mailto:postgres@10.16.0.121" moz-do-not-send="true">postgres@...1</a> /usr/pgsql-9.6/bin/pg_ctl -D
/var/lib/pgsql/9.6/data promote
Also why would it change my directory path from pgsql-9.6 to pgsql-9.5 when that is coded in (not a variable)?
Thanks again
</pre>
<div class="moz-cite-prefix">On 01/18/2018 03:39 PM, Tatsuo Ishii
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20180119.073901.2059827019941395695.t-ishii@sraoss.co.jp">
<pre wrap="">H is "host name of the new master node", which means the first live
backend host name. For example if you have backend_hostname0,
backend_hostname1, backend_hostname2 and backend_hostname0 goes down,
then %H = backend_hostname1. You need to promote the standby only if
your primary node goes down. If the standby</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>