Issues with postgres

[timaschew]

First of all thank you for providing this detailed instructions! 🙏

I have some issues with the database.
I've created the postgres database successfully but when starting the matrix app it tells me

psycopg2.OperationalError: FATAL: database "synapsedb" does not exist

When I login via psql I see this

postgres=# \l
                             List of databases
   Name    |  Owner   | Encoding  | Collate | Ctype |   Access privileges
-----------+----------+-----------+---------+-------+-----------------------
 postgres  | postgres | SQL_ASCII | C       | C     |
 template0 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
 template1 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
(3 rows)

Which confirms that there is no database with the name synapsedb.

[p3nj]

this can be fixed by
$ psql -U postgres

CREATE DATABASE synapsedb 
WITH 
  LC_CTYPE='C'
  LC_COLLATE='C' 
  ENCODING='UTF8' 
  TEMPLATE=template0;

[timaschew]

Thanks, I've also submitted a PR to the dokku postgres plugin to fix via dokku commands: dokku/dokku-postgres#240