Installation for PowerCenter and Data Quality

Back Next

PostgreSQL Database Requirements

Use the following guidelines when you set up the repository on PostgreSQL:

Verify that the database user account has CONNECT, CREATE TABLE, and CREATE VIEW privileges.

Specify the database schema name when you use PostgreSQL as the database.

Ensure that PostgreSQL has sufficient disk space for the data files. By default, the data files are present in the following location:

<PostgreSQL installation directory>/data

On the database, set the configuration parameters.

The following table lists the minimum and recommended values for the configuration parameters that you must set: