Installation for Data Engineering

10.5.3
- 10.5.7
- 10.5.6
- 10.5.5.1
- 10.5.5
- 10.5.4
- 10.5.2
- 10.4.1
- 10.4.0

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:

Parameter	Minimum Value	Recommended Value
max_connections	200	4000
shared_buffers	2 GB	16 GB
max_locks_per_transaction	1024	4000
max_wal_size	1 GB	8 GB
checkpoint_timeout	5 minutes	30 minutes

To configure 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

Ensure that the entries for the [PCRS_DB_SERVICE_NAME] entry matches the information for the PowerCenter Repository Service. To securely connect to PostgreSQL for the PowerCenter repository, set the security property 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. The pg_service.conf file contains the connection parameters for PostgreSQL database connection in the Informatica installation directory. For example, set the variable as follows:

Using a Bourne shell:

$ export PGSERVICEFILE; PGSERVICEFILE=<pg_service.conf file 
directory>/pg_service.conf

Using a C shell:

$ setenv PGSERVICEFILE <pg_service.conf file 
directory>/pg_service.conf

Rename Saved Search

Table of Contents

Installation for Data Engineering

Installation for Data Engineering

PostgreSQL Database Requirements

PostgreSQL Database Requirements