From 0301c507208ff895645e23b1d766438af795ebbc Mon Sep 17 00:00:00 2001
From: Luke Hoersten <luke@hoersten.org>
Date: Sun, 14 Jun 2020 15:22:14 -0500
Subject: Added postgresql for prosody.

---
 prosody/templates/setup_db.psql.j2 | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 prosody/templates/setup_db.psql.j2

(limited to 'prosody/templates/setup_db.psql.j2')

diff --git a/prosody/templates/setup_db.psql.j2 b/prosody/templates/setup_db.psql.j2
new file mode 100644
index 0000000..25e9ec0
--- /dev/null
+++ b/prosody/templates/setup_db.psql.j2
@@ -0,0 +1,2 @@
+CREATE USER {{prosody_db}} WITH ENCRYPTED PASSWORD '{{prosody_db_pass}}';
+CREATE DATABASE {{prosody_db}} ENCODING 'UTF8' LC_COLLATE='C.UTF-8' LC_CTYPE='C.UTF-8' template=template0 OWNER {{prosody_db}};
-- 
cgit v1.2.3