diff options
Diffstat (limited to 'prosody/templates/setup_db.psql.j2')
| -rw-r--r-- | prosody/templates/setup_db.psql.j2 | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/prosody/templates/setup_db.psql.j2 b/prosody/templates/setup_db.psql.j2 index 25e9ec0..fd4f430 100644 --- a/prosody/templates/setup_db.psql.j2 +++ b/prosody/templates/setup_db.psql.j2 @@ -1,2 +1,3 @@ -CREATE USER {{prosody_db}} WITH ENCRYPTED PASSWORD '{{prosody_db_pass}}'; +CREATE USER {{prosody_db}}; +ALTER USER {{prosody_db}} WITH 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}}; |