[pgpool-general: 5877] Re: failover command

chris chrisk at pgsqlrocket.com
Sat Jan 20 00:34:40 JST 2018

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 

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/cbeca2ed/attachment.html>

More information about the pgpool-general mailing list