diff options
Diffstat (limited to 'prosody/templates/setup_db.psql.j2')
| -rw-r--r-- | prosody/templates/setup_db.psql.j2 | 2 |
1 files changed, 2 insertions, 0 deletions
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}}; |