pgpool 之七 脚本 pgpool_remote_start

pgpool_remote_start
This script is run after recovery_1st_stage to start Standby node.

$ vi /data/pg9.6/main/pgpool_remote_start

#!/bin/bash

if [ $# -ne 2 ]
then
    echo "pgpool_remote_start remote_host_name remote_pgdata"
    exit 1
fi

REMOTE_HOST_NAME=$1
REMOTE_PGDATA=$2
PGCTL=/usr/lib/postgresql/9.6/bin/pg_ctl
PGCONF=/etc/postgresql/9.6/main/postgresql.conf

echo "`date +%Y-%m-%d\ %H:%M:%S,%3N` pgpool: FATAL: pgpool_remote_start /usr/bin/ssh -T $REMOTE_HOST_NAME $PGCTL -w -D $REMOTE_PGDATA start"
# /usr/bin/ssh -T $REMOTE_HOST_NAME "$PGCTL -w start -D $REMOTE_PGDATA 2>/dev/null 1>/dev/null < /dev/null & "
/usr/bin/ssh -T $REMOTE_HOST_NAME "$PGCTL -w start -D $REMOTE_PGDATA -o \"-c config_file=$PGCONF\" 2>/dev/null 1>/dev/null < /dev/null & "

$ chmod 700 /data/pg9.6/main/pgpool_remote_start

参考:
http://www.pgpool.net/docs/latest/en/html/example-cluster.html