From c3b3d832a2a53b32ab561ca38fe37df820615e90 Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Sun, 14 Jun 2020 15:22:25 -0500 Subject: Fixed psql sytnax --- matrix-synapse/templates/setup_db.psql.j2 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'matrix-synapse/templates/setup_db.psql.j2') diff --git a/matrix-synapse/templates/setup_db.psql.j2 b/matrix-synapse/templates/setup_db.psql.j2 index dee0478..775b52c 100644 --- a/matrix-synapse/templates/setup_db.psql.j2 +++ b/matrix-synapse/templates/setup_db.psql.j2 @@ -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}}; -- cgit v1.2.3