[pgpool-general: 5879] Re: failover command

[Tatsuo Ishii]

> After reading a post from Tatsuo Ishii:
> 
> (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.

Storange. Especially "/usr/pgsql-9.5/bin/pg_ctl -D" was gotten instead
of "/usr/pgsql-9.6/bin/pg_ctl -D" since Pgpool-II should not be able
to do that.

Will look into this.

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

> On 01/19/2018 08:34 AM, chris wrote:
>>
>> 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:
>>
>> ssh -Tpostgres at ...0  /usr/pgsql-9.5/bin/pg_ctl -D
>> /var/lib/pgsql/9.6/data promote
>>
>>
>> when instead I want it to be:
>>
>>
>> ssh -Tpostgres at ...1  /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
>>
>> On 01/18/2018 03:39 PM, Tatsuo Ishii wrote:
>>> 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
>>
>