[pgpool-general: 5878] Re: failover command

[chris]

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.

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
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180119/ca857302/attachment.html>