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