[pgpool-general: 5880] Re: failover command

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jan 23 13:38:00 JST 2018


Which version of Pgpool-II are you using?

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

>> 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
>>>
>> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list