Mention that postgres databases must have the correct charset encoding

1 files changed, 17 insertions, 0 deletions

diff --git a/docs/postgres.rst b/docs/postgres.rst

index a04ab12b1a..d645e1d697 100644
--- a/docs/postgres.rst
+++ b/docs/postgres.rst
@@ -1,6 +1,23 @@
 Using Postgres
 --------------
 
+Set up database
+===============
+
+The PostgreSQL database used *must* have the correct encoding set, otherwise
+would not be able to store UTF8 strings. To create a database with the correct
+encoding use, e.g.::
+
+ CREATE DATABASE synapse
+  ENCODING 'UTF8'
+  LC_COLLATE='C'
+  LC_CTYPE='C'
+  template=template0
+  OWNER synapse_user;
+
+This would create an appropriate database named ``synapse`` owned by the
+``synapse_user`` user (which must already exist).
+
 Set up client
 =============