Installing and configuring an external PostgreSQL database - 7.3

Talend Data Catalog Installation and Upgrade Guide

Version
7.3
Language
English
Operating system
Linux
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Catalog
Content
Installation and Upgrade
Last publication date
2023-03-15
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