PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For the purposes of this recipe, pgha1 will remain our primary node, and the standby will be pgha2. Follow these steps on pgha1 and pgha2, unless otherwise specified:

1. Create a file named repmgr_promote_self.sh in the /usr/local/bin folder and specify the following contents:

#!/usr/bin/env bash 
 
VIP=10.0.30.50 
IFACE=eth0 
PATH=/usr/pgsql-12/bin:$PATH 
VIP_CONF="${VIP}/32 dev ${IFACE} label ${IFACE}:pg" 
 
ssh -o StrictHostKeyChecking=no \ 
    -o UserKnownHostsFile=/dev/null \ 
    -o ConnectTimeout=5 \ 
    -o ServerAliveInterval=1 \ 
    postgres@${VIP} sudo ip addr del ${VIP_CONF} 
 
sudo /sbin/ip addr add ${VIP_CONF} 
sudo /usr/sbin/arping -b -A -c 3 -I ${IFACE} ${VIP} 
 
repmgr standby promote 
exit 0 

2. Mark the script as executable with this command ...