matrix-synapse/templates/setup_db.psql.j2
author Luke Hoersten <luke@hoersten.org>
Sun, 05 Jul 2020 10:25:32 -0500
changeset 118 56bffa9ef826
parent 46 f43ad090546d
permissions -rw-r--r--
Added nginx and oragono HUP reloading to systemd handlers. Added nginx config.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
39
90b1b7c4be70 Added pgsql support for matrix.
Luke Hoersten <luke@hoersten.org>
parents:
diff changeset
     1
CREATE USER {{matrix_synapse_pgsql_user}} WITH ENCRYPTED PASSWORD '{{matrix_synapse_pgsql_pass}}';
46
f43ad090546d Fixed psql sytnax
Luke Hoersten <luke@hoersten.org>
parents: 39
diff changeset
     2
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}};