POSTGRES_HOST="localhost"
POSTGRES_DBNAME="tinyowl_production"
POSTGRES_USER=“geo_rails"

psql --host="$POSTGRES_HOST" --username="$POSTGRES_USER" --dbname="$POSTGRES_DBNAME" -c "SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'tinyowl_production' AND pid <> pg_backend_pid();"

dropdb --host="$POSTGRES_HOST" --username="$POSTGRES_USER" "$POSTGRES_DBNAME”

createdb --host="$POSTGRES_HOST" --username="$POSTGRES_USER" "$POSTGRES_DBNAME”

psql --host="$POSTGRES_HOST" --username="$POSTGRES_USER" --dbname="$POSTGRES_DBNAME" < pgdump.sql