From 8549ee0f1aeb61a78029bc9f104d30a31a737500 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sun, 11 Aug 2013 10:01:11 -0400
Subject: [PATCH] Add drop and load convenience script.

---
 scripts/drop_and_load.shl | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100755 scripts/drop_and_load.shl

diff --git a/scripts/drop_and_load.shl b/scripts/drop_and_load.shl
new file mode 100755
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
-- 
2.39.2