Table of Contents

Search

  1. About the Test Data Management Configuration Guide
  2. Test Data Management Configuration Overview
  3. Before You Configure Test Data Management
  4. Prepare for Application Services and Databases
  5. Create the Application Services
  6. Configure Test Data Management
  7. Starting and Stopping Informatica Services
  8. Appendix A: Infacmd

Configuration Guide

Configuration Guide

PostgreSQL Database Requirements

PostgreSQL Database Requirements

You can create a test data warehouse repository on a PostgreSQL database.
Use the following guidelines when you create a test data warehouse repository on PostgreSQL:

Configuration parameters

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.

Disk Space

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

Privileges

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

Database Schema Name

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

0 COMMENTS

We’d like to hear from you!