Installing and configuring an external PostgreSQL database - 7.3

Talend Data Catalog Installation and Upgrade Guide for Windows

author
Talend Documentation Team
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
task
Installation and Upgrade
EnrichPlatform
Talend Data Catalog
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/windows/ and install it.
    For more information on the supported versions of the databases, see Compatible databases.
  2. Add PostgreSQL to the PATH environment variable.
  3. 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;
  4. 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;
  5. Disconnect and switch to mm user:
    postgres=# \q
    C:\>psql -U mm mm