Installing and configuring an external PostgreSQL database

The following steps describe how to install and configure an external PostgreSQL database.

For more information, refer to the PostgreSQL database documentation at https://www.postgresql.org/.

Procedure

Download a PostgreSQL instance from https://www.postgresql.org/download/linux/ and install it.
For more information on the supported versions of the databases, see Compatible databases.
Connect to PostgreSQL as the default postgres superuser et create the mm user with a password using the following command:
```
$ sudo su - postgres
$ psql postgres
postgres=# CREATE ROLE mm WITH PASSWORD 'mm123!';
```
Create the mm database and grant privileges on this new database to the mm user:
```
postgres=# CREATE DATABASE mm;
postgres=# GRANT ALL PRIVILEGES ON DATABASE mm TO mm;
```

Disconnect and switch to mm user:

postgres=# \q
$ su – mm
$ psql -d mm -U mm

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!