--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/prosody/templates/setup_db.psql.j2	Sun Jun 14 15:22:14 2020 -0500
@@ -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}};