#!/bin/bash
# Recovery script for synchronizing new DB node via streaming replication - 2nd stage

# Checking number of passed arguments.
if [ $# -ne 5 ] ; then
	logger -i pgpool_recovery_2nd_stage: Script was ran with wrong number of arguments.
	exit 1
fi

# Setting variables.
SOURCE_PGDATA=$1
TARGET_HOST=$2
TARGET_PGDATA=$3
SOURCE_PORT=$4
TARGET_NODE=$5

PG_UTILS_DIR=/usr/pgsql-11/bin

#Switching WAL file.
logger -i pgpool_recovery_2nd_stage: Switching WAL file...

$PG_UTILS_DIR/psql -c "SELECT pg_switch_wal();"

if [ $? - ne 0 ]; then
	logger -i pgpool_recovery_2nd_stage: WAL file could no be switched!
	exit 1;
else
	logger -i pgpool_recovery_2nd_stage: WAL file was switched.
fi

logger -i pgpool_recovery_2nd_stage: Ending the second stage.