add postgres database creation script

1 files changed, 8 insertions, 0 deletions

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