From 520cf4ab2ca7474a6cce67531b305ed0fee20548 Mon Sep 17 00:00:00 2001
From: squahtx
COLLATE
or CTYPE
Synapse will refuse to set up a new database if it has the wrong values of
-COLLATE
and CTYPE
set, and will log warnings on existing databases. Using
-different locales can cause issues if the locale library is updated from
+COLLATE
and CTYPE
set. Synapse will also refuse to start an existing database with incorrect values
+of COLLATE
and CTYPE
unless the config flag allow_unsafe_locale
, found in the
+database
section of the config, is set to true. Using different locales can cause issues if the locale library is updated from
underneath the database, or if a different version of the locale is used on any
replicas.
The safest way to fix the issue is to dump the database and recreate it with +
If you have a databse with an unsafe locale, the safest way to fix the issue is to dump the database and recreate it with
the correct locale parameter (as shown above). It is also possible to change the
parameters on a live database and run a REINDEX
on the entire database,
however extreme care must be taken to avoid database corruption.