The following steps describe how to install and configure an external PostgreSQL
database.
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