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/windows/ and install it.
For more information on the supported versions of the databases, see Compatible databases.
Add PostgreSQL to the PATH environment variable.
From the Windows command line, connect to PostgreSQL as the default postgres superuser et create the mm database using the following command:
```
C:\>psql -U postgres
postgres=# CREATE DATABASE mm;
```
Create the mm user and grant privileges on the mm database to the mm user using the following command:
```
postgres=# CREATE ROLE mm WITH LOGIN PASSWORD 'mm123!';
postgres=# GRANT ALL PRIVILEGES ON DATABASE mm TO mm;
```
Disconnect and switch to mm user:
```
postgres=# \q
C:\>psql -U mm 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!