postgres import sql

#/bin/bash

if [ $# -ne 2 ]; then
    echo $0: usage: myscript databasename zipfile
    exit 1
fi

dbname=$1

psql --command "select pg_terminate_backend(procpid) from pg_stat_activity where datname = '$dbname';"
dropdb $dbname
createdb $dbname
gunzip -c ${2} | psql $dbname
psql $dbname --command "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO admin ;"
psql $dbname --command "GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO admin ;"
if [ -f "post_$dbname.sql" ]
then
        cat "post_$dbname.sql" | psql $dbname
fi;