Pgpool-II实现高可用+读写分离+负载均衡（六）---- escalation.sh分析

#!/bin/bash# 本脚本由wd_escalation_command调用，为在新的leader节点上绑定浮动IP。# 需要先调用些脚本遍历所有Pgpool节点，解绑浮动IP。set-o xtrace
# PostgreSQL启动用户POSTGRESQL_STARTUP_USER=postgres
SSH_KEY_FILE=id_rsa
SSH_OPTIONS="-o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -i ~/.ssh/${SSH_KEY_FILE}"# 节点列表PGPOOLS=(db01 db2 db03)
# 浮动IPVIP=192.168.0.5
# 绑定浮动IP的设备名DEVICE=eth0
for pgpool in"${PGPOOLS[@]}"; do    [ "$HOSTNAME"="$pgpool" ] && continue
ssh-T${SSH_OPTIONS}${POSTGRESQL_STARTUP_USER}@$pgpool"                /usr/bin/sudo /usr/sbin/ip addr del $VIP/32 dev $DEVICE    "doneexit0

#!/bin/bash# This script is run after recovery_1st_stage to start Standby node.set-o xtrace
DEST_NODE_HOST="$1"DEST_NODE_PGDATA="$2"PGHOME=/usr/local/pgsql14
POSTGRESQL_STARTUP_USER=postgres
SSH_KEY_FILE=id_rsa
SSH_OPTIONS="-o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -i ~/.ssh/${SSH_KEY_FILE}"echo pgpool_remote_start: start: remote start Standby node$DEST_NODE_HOST## Test passwordless SSHssh-T${SSH_OPTIONS}${POSTGRESQL_STARTUP_USER}@${DEST_NODE_HOST}ls /tmp > /dev/null
if [ $?-ne0 ]; thenecho ERROR: pgpool_remote_start: passwordless SSH to ${POSTGRESQL_STARTUP_USER}@${DEST_NODE_HOST} failed. Please setup passwordless SSH.
exit1fi## Start Standby nodessh-T${SSH_OPTIONS}${POSTGRESQL_STARTUP_USER}@${DEST_NODE_HOST}"$PGHOME/bin/pg_ctl -l /dev/null -w -D ${DEST_NODE_PGDATA} status    if [ \$? -eq 0 ]; then        exit 0    fi$PGHOME/bin/pg_ctl -l /dev/null -w -D ${DEST_NODE_PGDATA} start"if [ $?-ne0 ]; thenecho ERROR: pgpool_remote_start: ${DEST_NODE_HOST} PostgreSQL start failed.
exit1fiecho pgpool_remote_start: end: PostgreSQL on ${DEST_NODE_HOST} is started successfully.
exit0