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 CREATE TABLE and CREATE VIEW privileges.

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:

To install PostgreSQL database for the PowerCenter repository, set values for the PostgreSQL database host, port, and service name for the

pg_service.conf

file in the following format:

[PCRS_DB_SERVICE_NAME]
host=Database host IP
port=Database port
dbname=PowerCenter Repository Service database service name

To securely connect to PostgreSQL for the PowerCenter repository, set the

sslmode

require

along with the remaining required database properties in the

pg_service.conf

file in the following format:

sslmode=require

Set the PGSERVICEFILE environment variable to the location of the

pg_service.conf

file in the Informatica installation directory.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.