From 55636242fb42009fac80656ad5106ad2717bcd75 Mon Sep 17 00:00:00 2001
From: pepperpepperpepper <pepper@scannerjammer.com>
Date: Tue, 6 Oct 2015 20:02:47 -0700
Subject: added some new scripts

---
 dumpfm/postgres_init.sh | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 dumpfm/postgres_init.sh

(limited to 'dumpfm/postgres_init.sh')

diff --git a/dumpfm/postgres_init.sh b/dumpfm/postgres_init.sh
new file mode 100644
index 0000000..7bd6cc8
--- /dev/null
+++ b/dumpfm/postgres_init.sh
@@ -0,0 +1,13 @@
+initdb --locale en_US.UTF-8 -E UTF8 -D '/mnt/sdb1/DUMPFM_BACKUP/pg'
+postgres -D /mnt/sdb1/DUMPFM_BACKUP/pg
+#fix whatever issues with permissions
+#createdb dumpfm
+#createuser postgres
+#psql ...
+
+#
+#
+#
+#REVOKE CONNECT ON DATABASE dumpfm FROM PUBLIC; GRANT CONNECT ON DATABASE database_name TO postgres;
+#psql -U postgres -d dumpfm < /mnt/sdb1/DUMPFM_BACKUP/dumpfmpgsql-1444088905.sql 
+
-- 
cgit v1.2.3-70-g09d2