该恢复过程为手工触发脚本,半自动执行。
su - pg93
cd $PGDATA
上传basebackup.sh文件到各个节点的相同目录中。
首先根据实际主备节点IP编辑脚本内容
#! /bin/sh
# Recovery script for streamingreplication.
# This script assumes that DB node 0 isprimary, and 1 is standby.
# ./basebackup.sh /home/pg93/pg_root192.168.160.128
# ifconfig eth0 | grep "inetaddr:" | awk '{print $2}' | cut -c 6-
# `ifconfig eth0 | grep "inetaddr" | awk -F: '{print $2}' | awk '{print $1}'`
# `ifconfig eth0 | grep "inet" |awk '{print $2}'`
datahost=$1
datadir="/home/pg93/pg_root" 主节点数据库目录
desthost=$2
destdir="/home/pg93/pg_root" 备节点数据库目录
pgpoolhost=172.16.0.195 pgpool-ii 的IP
h0=172.16.0.195