#!/bin/sh

export PGPASSWORD='Finance@unicom23'
backup_dir=$1
host='172.16.107.5'
port='5432'
username='finance'
dbname='financialdb'
jobs='16'
if [ "$(psql -U ${username} -tAc "SELECT 1 FROM pg_database WHERE datname='${dbname}'")" != "1" ]; then
    createdb -U ${username} ${dbname}
fi
pg_restore -O -c -v -h "${host}" -p "${port}" -U "${username}" -d "${dbname}" -Fd -j "${jobs}" "${backup_dir}"