diff options
| author | Luke Hoersten <[email protected]> | 2020-06-14 15:22:14 -0500 |
|---|---|---|
| committer | Luke Hoersten <[email protected]> | 2020-06-14 15:22:14 -0500 |
| commit | 0301c507208ff895645e23b1d766438af795ebbc (patch) | |
| tree | dd62fcbb7e16dd0e7d642a3dec60f566864c69d1 /prosody/templates/setup_db.psql.j2 | |
| parent | 2f583cf15c00744ed6799c06ed71fde73c7ba839 (diff) | |
Added postgresql for prosody.
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}}; |