3 # user doing the load - must be superuser, and must have access to postgres db
6 # full path to the backup file
9 psql -U $USER -h localhost postgres <<EOF
10 drop database xonstatdb;
11 create database xonstatdb encoding='utf-8' owner=xonstat;
15 pg_restore -c -U xonstat -h localhost -d xonstatdb $BACKUPFILE