Make sure the database you are using meet the requirements described in Compatible databases and the following ones.
Before you begin
Log in to an existing database as a database superuser or a user who has
CREATEROLE and CREATEDB
psql.exe -h <HOST-NAME> -W -U <USER_NAME> -p <PORT> -d <DATABASE_NAME>
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 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;
For maintenance reasons, PostgreSQL database indexes can be rebuilt as
For more information on
- Stop the Talend Data Catalog application server.
- Run the following command under the MS-DOS command prompt assuming
postgresql/bin is in the system
reindexdb --username=MM --dbname=MM -v
- Restart the Talend Data Catalog application server.
reindexdb, refer to the PostgreSQL documentation.