Configuring a database on PostgreSQL - 7.1

Talend Data Catalog Installation and Upgrade Guide for Linux

Version
7.1
Language
English (United States)
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

Before you begin

Make sure the database you are using meets the requirements described in Compatible databases.

Procedure

  1. Log in to an existing database as a database superuser or a user who has CREATEROLE and CREATEDB privileges.
    $ psql <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'll 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 database MM with UTF8 encoding. You may use a different tablespace.
        CREATE DATABASE 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;
    
  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.