# HG changeset patch # User Luke Hoersten # Date 1592166145 18000 # Node ID f43ad090546d5fef844c6a1d0d9535a895bac540 # Parent 2d7ba960b157cfbe3ce9643b0ec554239d45d8d2 Fixed psql sytnax diff -r 2d7ba960b157 -r f43ad090546d 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}};