pgwarmsby.sh

#!/bin/sh

. pgcommon.sh

PGSTANDBY=$PGBIN/pg_standby

ACTDATA=$CURDIR/data
ACTCONF=$ACTDATA/$GUCFILENAME
ACTPORT=5432
ACTPREFIX=data

SBYDATA=$CURDIR/sby
SBYCONF=$SBYDATA/$GUCFILENAME
SBYPORT=5433
SBYPREFIX=sby

PGARCH=$ACTDATA.arch
PGBKP=$ACTDATA.bkp
TRIGGER=$CURDIR/trigger
RECOVERYCONF=$SBYDATA/$RECFILENAME
RECOVERYSIGNAL=$SBYDATA/$RECSIGNALNAME
STANDBYSIGNAL=$SBYDATA/$SBYSIGNALNAME

COPYMODE=false

usage ()
{
cat <<EOF
$PROGNAME configures warm-standby

Usage:
  $PROGNAME [OPTIONS]

Description:
  $PROGNAME creates warm-standby environement by using pg_standby as
  restore_command by default.

Options:
  -c, --copy      use 'cp' as restore_command (possible in 9.0 or later)
EOF
}

while [ $# -gt 0 ]; do
	case "$1" in
		-c|--copy)
			COPYMODE=true;;
		"-?"|--help)
			usage
			exit 0;;
		*)
			elog "invalid option: $1";;
	esac
	shift
done

here_is_installation
validate_archiving

if [ $PGMAJOR -lt 82 ]; then
	elog "warm-standby is not supported"
fi

if [ "$COPYMODE" = "true" ]; then
	if [ $PGMAJOR -lt 90 ]; then
		elog "copy mode (-c) requires v9.0 or later"
	fi
else
	if [ ! -f $PGSTANDBY ]; then
		elog "pg_standby must be installed"
	fi
fi

rm -rf $ACTDATA $SBYDATA $PGARCH $TRIGGER

pginitdb.sh $ACTDATA
pgarch.sh $ACTDATA

set_guc port $ACTPORT $ACTCONF
set_guc log_line_prefix "'$LOGLINEPREFIX $ACTPREFIX '" $ACTCONF

pgstart.sh -w $ACTDATA
pgbackup.sh $ACTDATA
cp -r $PGBKP $SBYDATA

set_guc port $SBYPORT $SBYCONF
set_guc log_line_prefix "'$LOGLINEPREFIX $SBYPREFIX '" $SBYCONF

if [ $PGMAJOR -ge 90 ]; then
	set_guc hot_standby on $SBYCONF
fi

if [ "$COPYMODE" = "true" ]; then
	if [ $PGMAJOR -ge 120 ]; then
		set_guc restore_command "'cp $PGARCH/%f %p'" $SBYCONF
		set_guc promote_trigger_file "'$TRIGGER'" $SBYCONF
		touch $STANDBYSIGNAL
	else
		echo "standby_mode = 'on'" >> $RECOVERYCONF
		echo "restore_command = 'cp $PGARCH/%f %p'" >> $RECOVERYCONF
		echo "trigger_file = '$TRIGGER'" >> $RECOVERYCONF
	fi
else
	RESTORECMD="$PGSTANDBY -t $TRIGGER -r 1 $PGARCH %f %p"
	if [ $PGMAJOR -ge 120 ]; then
		set_guc restore_command "'$RESTORECMD'" $SBYCONF
		touch $RECOVERYSIGNAL
	else
		echo "restore_command = '$RESTORECMD'" > $RECOVERYCONF
	fi
fi

pgstart.sh $SBYDATA