From 16ee10eb5093a5b324782e1bd3ac01b75009f8f7 Mon Sep 17 00:00:00 2001
From: Wojciech Kosior <kwojtus@protonmail.com>
Date: Thu, 28 May 2020 21:10:29 +0200
Subject: add postgres database creation script

---
 setup_postgres.sh | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100755 setup_postgres.sh

diff --git a/setup_postgres.sh b/setup_postgres.sh
new file mode 100755
index 0000000..f026645
--- /dev/null
+++ b/setup_postgres.sh
@@ -0,0 +1,8 @@
+#!/bin/sh
+
+echo "Creating 'ztdns' role"
+sudo -u postgres createuser --no-createdb --no-createrole \
+     --no-superuser --pwprompt ztdns
+
+echo "Creating 'ztdns' database"
+sudo -u postgres createdb -O ztdns ztdns
-- 
cgit v1.2.3