pgpool failover script(pg_ctl promote) failover_command = '/path/to/pgpool_failover_stream.sh %d %H %R'

pgpool_failover.sh

#!/bin/bash

set -e

SSH=/usr/bin/ssh
PGCTL=/usr/bin/pg_ctl

failed_node=$1
new_master=$2
cluster_path=$3

# Do nothing if standby goes down.
if [ $failed_node != 0 ]; then
  echo "node number:$failed_node is standby. skip"
  exit 0;
fi

# execute promote
$SSH -T $new_master $PGCTL promote -D $cluster_path
echo "$new_master has been promoted from slave to temp master"