Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Updating the DynamicSections Parameter of a DB2 Database

Installation for Data Engineering

Installation for Data Engineering

PostgreSQL Database Requirements

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 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
    to
    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.