restore postgres db dump

restore.sh

#!/bin/bash
set -x
set -e

if [ $1 ] ; then
    DB=$1
fi

if [ $2 ]; then
    FILE=$2
fi

if [ $3 ]; then
    LIST="-L $3"
fi

# drop connections
psql -ec "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = '$DB' AND pid <> pg_backend_pid();" postgres

dropdb $DB
createdb -O $DB $DB
pg_restore -vO -j4 $LIST -U $DB -d $DB $FILE