Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Linux
  4. Before You Upgrade the Domain on UNIX
  5. Before You Upgrade the Domain on Windows
  6. Prepare for the Upgrade
  7. Upgrade the Domain
  8. Upgrade the Domain with Changes to Node Configuration
  9. Before You Upgrade the Application Services
  10. Application Service Upgrade
  11. Informatica Client Upgrade
  12. After You Upgrade
  13. Upgrade Checklist

Upgrading from Version 10.2 (10.4.1)

Upgrading from Version 10.2 (10.4.1)

Migrating to PostgreSQL

Migrating to PostgreSQL

Effective in version 10.4.0, you can use PostgreSQL for the domain configuration repository database, PowerCenter repository database, the monitoring Model repository database, or for the Model repository database.
To use the PostgreSQL database for the existing services, complete the following tasks after you upgrade the domain and services to version 10.4.0:
  1. Create a PostgreSQL database. For more information about creating a database, see the
    Informatica 10.4.0 Application Service Guide
    .
  2. Enter the required commands to configure the domain and repositories:
    Domain
    To back up the domain, enter the following command:
    infasetup BackupDomain
    To update the domain with PostgreSQL database, enter the following command:
    infacmd isp UpdateRepositoryService
    To restore the domain to PostgreSQL, enter the following command and set the database type and schema name to PostgreSQL :
    infasetup RestoreDomain
    PowerCenter Repository
    To back up the PowerCenter repository, enter the following command:
    pmrep backup
    To update the PowerCenter Repository Service with PostgreSQL database, enter the following command:
    infacmd isp UpdateRepositoryService
    To recycle the service, enter the following command:
    infacmd isp EnableService
    To restore the PowerCenter repository with PostgreSQL database type, enter the following command:
    pmrep restore
    Model Repository
    To back up the Model Repository Service, enter the following command:
    infacmd mrs BackupContents
    To update the Model Repository Service with PostgreSQL database, enter the following command:
    infacmd mrs UpdateServiceOptions
    To recycle the service, enter the following command:
    infacmd isp EnableService
    To restore the Model Repository Service with PostgreSQL database type, enter the following command:
    infacmd mrs restoreContents
  3. Set the following environment variable for PostgreSQL for the PowerCenter Repository Service:
    PGSERVICE: Set to the location of the pg_service.conf file: <pg_service.conf file directory>/pg_service.conf PGHOME: Set to PostgreSQL client install location. For example, /usr/pgsql -10 Add to PATH: $PGHOME:${PATH} Add to LD_LIBRARY_PATH: $PGHOME/lib:${LD_LIBRARY_PATH}

0 COMMENTS

We’d like to hear from you!