Installing and configuring an external PostgreSQL database - 7.3

Talend Data Catalog Installation and Upgrade Guide for Linux

EnrichVersion
7.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog
task
Installation and Upgrade
The following steps describe how to install and configure an external PostgreSQL database.

Procedure

  1. 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.
  2. 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!';
  3. 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;
  4. Disconnect and switch to mm user:
    postgres=# \q
    $ su – mm
    $ psql -d mm -U mm