#!/bin/bash
#
#
#

STAGE=$1

DATADIR='/var/lib/postgresql/13/main'
DATE=$(date +%F)

PG_USER=postgres
PG_GROUP=postgres

systemctl stop postgresql

rm -rf ${DATADIR}_moved

mv ${DATADIR} ${DATADIR}_moved
mkdir -p ${DATADIR}

LOCAL_BACKUP_DIR="/home/backupuser/backups/${STAGE}/postgres"
BACKUP_FILE_ENCRYPTED=$(find "${LOCAL_BACKUP_DIR}/${DATE}/" -name *.gz.gpg | head -n 1)

# --batch  => avoid error: >> gpg: cannot open '/dev/tty': No such device or address" <<
gpg --batch --decrypt $BACKUP_FILE_ENCRYPTED | tar -xz -C ${DATADIR}

chmod 0700 ${DATADIR}
chown -R ${PG_USER}:${PG_GROUP} ${DATADIR}

systemctl start postgresql
