From d6ec0850b896918faf83f0eab325ec8c1f89e2bb Mon Sep 17 00:00:00 2001
From: tom barrett <spalf0@gmail.com>
Date: Fri, 22 Mar 2019 11:38:32 -0500
Subject: added postgres vagrant instance and test to check connection

---
 postgres/bootstrap.sh | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 postgres/bootstrap.sh

(limited to 'postgres/bootstrap.sh')

diff --git a/postgres/bootstrap.sh b/postgres/bootstrap.sh
new file mode 100644
index 0000000..03f7eef
--- /dev/null
+++ b/postgres/bootstrap.sh
@@ -0,0 +1,20 @@
+#!/bin/bash
+
+# prepare deps
+export DEBIAN_FRONTEND=noninteractive
+apt-get update
+apt-get upgrade -y
+apt-get install -y xauth
+
+# deps
+apt-get install -y postgresql postgresql-client
+
+# set up db
+sudo -u postgres psql -c "CREATE USER space WITH PASSWORD 'space';"
+sudo -u postgres psql -c "CREATE DATABASE space_db WITH OWNER space;"
+
+# copy configs
+cp /vagrant/postgres/*conf /etc/postgresql/9.6/main/
+
+# systemd
+systemctl restart postgresql
-- 
cgit v1.2.3