[pgpool-general: 6194] Re: New master id (%m) is -1 after failover?
Tatsuo Ishii
ishii at sraoss.co.jp
Sat Aug 11 13:02:21 JST 2018
Can you please tell the exact Pgpool-II version?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> How is that possible that new master id -1?
> Is that a valid case?
>
> failover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %M %H %P %r
> %R'
> # Executes this command at failover
> # Special values:
> # %d = node id
> # %h = host name
> # %p = port number
> # %D = database cluster path
> # %m = new master node id
> # %H = hostname of the new master node
> # %M = old master node id
> # %P = old primary node id
> # %r = new master port number
> # %R = new master database cluster path
> # %% = '%' character
>
> failover.sh,
>
> failed_node_id=$1
> failed_host=$2
> failed_port=$3
> failed_dir=$4
> new_master_id=$5
> old_master_id=$6
> new_master_host=$7
> old_primary_node_id=$8
> new_master_port=$9
> new_master_dir=${10}
>
> failover.log,
>
> [ failed node ]
> failed_node_id 1
> failed_host 192.168.20.58
> failed_port 5433
> failed_dir /opt/redsky/db/data
>
> [ before failover ]
> old_primary_node_id 1
> old_master_id 1
>
> [ after failover ]
> new_master_id -1
> new_master_host
> new_master_port
> new_master_dir
More information about the pgpool-general
mailing list