Assuming

  • PostgreSQL is installed.
  • Synapse and the various bridges will use the same database.

Do the following

  • Create a user

      sudo -u postgres createuser --pwprompt synapse

    This will prompt for a password; record the password: it will need to go into the synapse configuration file.

  • Create databases owned by this user as needed for

    • synapse

    • mautrix-facebook

    • mautrix-signal

    • mautrix-whatsapp

          sudo -u postgres createdb --encoding=UTF8 --locale=C --template=template0 --owner=synapse synapse
    sudo -u postgres createdb --encoding=UTF8 --locale=C --template=template0 --owner=synapse mautrix-facebook
    sudo -u postgres createdb --encoding=UTF8 --locale=C --template=template0 --owner=synapse mautrix-signal
    sudo -u postgres createdb --encoding=UTF8 --locale=C --template=template0 --owner=synapse mautrix-whatsapp