02-slave-install.sh

#!/bin/bash
#####################################################################################################
# This script will install Postgres as Slave Node on your Ubuntu 16.04 server.
# Author: Mohamed Hammad
#----------------------------------------------------------------------------------------------------
# Make a new file:
# sudo nano 02-slave-install.sh
# Place this content in it and then make the file executable:
# sudo chmod +x 02-slave-install.sh
# Execute the script to install Postgres:
# sudo ./02-slave-install.sh
#######################################################################################################

MASTER_IP="192.168.1.10"
SLAVE_IP="192.168.1.11"

#--------------------------------------------------
# Update Server
#--------------------------------------------------
echo -e "\n---- Update Server ----"
sudo apt update
sudo apt upgrade -yV

#--------------------------------------------------
# Install PostgreSQL Server
#--------------------------------------------------
echo -e "\n---- Install PostgreSQL Server ----"
sudo apt install postgresql-9.5 postgresql-9.5-repmgr postgresql-client-9.5 -yV

echo -e "\n---- Copy RSA keys sent from Node1 ----"
sudo chown postgres.postgres ~/authorized_keys ~/id_rsa.pub ~/id_rsa
sudo mkdir -p ~postgres/.ssh
sudo chown postgres.postgres ~postgres/.ssh
sudo mv ~/authorized_keys ~/id_rsa.pub ~/id_rsa ~postgres/.ssh
sudo chmod -R go-rwx ~postgres/.ssh

echo -e "\n---- Configure Replication Manager ----"
sudo mkdir -p /etc/repmgr
echo "cluster=Odoo
node=2
node_name=node2
use_replication_slots=1
conninfo='host=$SLAVE_IP user=repmgr dbname=repmgr'
pg_bindir=/usr/lib/postgresql/9.5/bin" | sudo tee -a /etc/repmgr/repmgr.conf

echo -e "\n---- Clone Master to Slave ----"
sudo su - postgres -c "ssh-keyscan -H $MASTER_IP >> ~/.ssh/known_hosts"
sudo service postgresql stop
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf --force --rsync-only -h $MASTER_IP -d repmgr -U repmgr --verbose standby clone"
sudo service postgresql restart
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf --force standby register"
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf cluster show"
echo -e "\nAll nodes should be shown in the above table..."

echo -e "\n---- Prepare Failover Scripts ----"
cat <<EOF > ~/promote-server
#!/bin/bash
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf standby promote"
EOF
cat <<EOF > ~/demote-server
#!/bin/bash
sudo service postgresql stop
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf --force --rsync-only -h $MASTER_IP -d repmgr -U repmgr --verbose standby clone"
sudo service postgresql restart
sudo su - postgres -c "repmgr -f /etc/repmgr/repmgr.conf --force standby register"
EOF
sudo chmod +x ~/promote-server
sudo chmod +x ~/demote-server

echo -e "\n---- Completed Slave Configuration Successfully ----"
echo -e "\n---- Go & Start Configuring PgBouncer Server ----"