Configuring a database on PostgreSQL - 8.0

Talend Data Catalog Installation and Upgrade Guide

Version
8.0
Language
English
Operating system
Windows
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
2024-01-26

Before you begin

Make sure the database you are using meet the requirements described in Compatible databases and the following ones.

Procedure

  1. Log in to an existing database as a database superuser or a user who has CREATEROLE and CREATEDB privileges.
    psql.exe -h <HOST-NAME> -W -U <USER_NAME> -p <PORT> -d <DATABASE_NAME>
  2. Create a user MM and a database MM with the following privileges.
    -- Delete previous user if needed
            DROP USER "MM";
    -- If the user cannot be dropped due to any ownership issues, you need to reassign those objects to another user
            REASSIGN OWNED BY "MM" TO <OTHER-USER-NAME>;
    -- Or drop those objects
            DROP OWNED BY "MM";
    -- Create a user MM with LOGIN privilege
            CREATE ROLE MM WITH LOGIN PASSWORD 'MM123!';
    -- Grant privileges on MM database to MM user
            GRANT ALL PRIVILEGES ON DATABASE MM TO MM;
    -- Create a database MM with UTF8 encoding
       CREATE DATABASE "MM" WITH OWNER "MM" ENCODING 'UTF8';
    
  3. For maintenance reasons, PostgreSQL database indexes can be rebuilt as follows.
    • Stop the Talend Data Catalog application server.
    • Run the following command under the MS-DOS command prompt assuming postgresql/bin is in the system path.
      reindexdb --username=MM --dbname=MM -v
    • Restart the Talend Data Catalog application server.
    For more information on reindexdb, refer to the PostgreSQL documentation.