db_restore.sh

#!/bin/bash

DBNAME=<database_name>
DBUSER=<database_user>
DBHOST=<host>

DUMP_FILE=$1

if [[ $DUMP_FILE == "" ]]; then
  echo "[ERROR] Arquivo de dump não especificado"
  echo "  usage:  restore.sh DUMP_FILE"
  exit 0
fi

dropdb --username=$DBUSER --host=$DBHOST $DBNAME
createdb --username=$DBUSER --host=$DBHOST $DBNAME
pg_restore -v --exit-on-error --single-transaction --no-owner --no-privileges --host=$DBHOST --dbname=$DBNAME --username=$DBUSER $DUMP_FILE

reindexdb --username=$DBUSER --host=$DBHOST --system
reindexdb --username=$DBUSER --host=$DBHOST $DBNAME
vacuumdb --full --analyze --username=$DBUSER --host=$DBHOST $DBNAME

exit $?