Fixed psql sytnax
authorLuke Hoersten <luke@hoersten.org>
Sun, 14 Jun 2020 15:22:25 -0500
changeset 46 f43ad090546d
parent 45 2d7ba960b157
child 47 3f1771bb0d79
Fixed psql sytnax
matrix-synapse/templates/setup_db.psql.j2
--- a/matrix-synapse/templates/setup_db.psql.j2	Sun Jun 14 15:22:14 2020 -0500
+++ b/matrix-synapse/templates/setup_db.psql.j2	Sun Jun 14 15:22:25 2020 -0500
@@ -1,2 +1,2 @@
 CREATE USER {{matrix_synapse_pgsql_user}} WITH ENCRYPTED PASSWORD '{{matrix_synapse_pgsql_pass}}';
-CREATE DATABASE {{matrix_synapse_pgsql_db}} ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' template=template0 WITH OWNER {{matrix_synapse_pgsql_user}};
+CREATE DATABASE {{matrix_synapse_pgsql_db}} ENCODING 'UTF8' LC_COLLATE='C.UTF-8' LC_CTYPE='C.UTF-8' template=template0 OWNER {{matrix_synapse_pgsql_user}};