Add drop and load convenience script.

diff --git a/scripts/drop_and_load.shl b/scripts/drop_and_load.shl
new file mode 100755 (executable)
index 0000000..8049afc
--- /dev/null
+++ b/scripts/drop_and_load.shl
@@ -0,0 +1,15 @@
+#!/bin/bash
+
+# user doing the load - must be superuser, and must have access to postgres db
+USER=xonstat
+
+# full path to the backup file
+BACKUPFILE=$1
+
+psql -U $USER -h localhost postgres <<EOF
+drop database xonstatdb;
+create database xonstatdb encoding='utf-8' owner=xonstat;
+\q
+EOF
+
+pg_restore -c -U xonstat -h localhost -d xonstatdb $BACKUPFILE