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	1024
max_wal_size	1 GB	8 GB
checkpoint_timeout	5 minutes	30 minutes

For information about configuring the database, see the documentation for the database system.

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

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.

Test Data Management creates a default storage connection and creates storage tables for the connection on the Test Data Management repository database. The storage connection and tables are required for expression masking and substitution masking with repeatable values.

Test Data Management creates a connection with the following details:

Name of the connection:
TDM_CONNECTION
Connection type:
JDBC

To use the storage connection created on a PostgreSQL database, you must add an entry to the following file:

<Informatica installation directory>/ODBC7.1/odbc.ini

The following code includes a sample entry:

[TDM_534_B465_1]
Driver=/home/ora11g/Informatica/105_B465/ODBC7.1/lib/DWpsql27.so
Description=DataDirect 7.1 PostgreSQL Wire Protocol
Database=TDM_534_B465_1
HostName=<host name>
PortNumber=5432
Workarounds2=2