Upgrading from Version 10.2 (10.4.0)

10.4.0
- 10.5.6
- 10.5.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1

Back Next

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:

Create a PostgreSQL database. For more information about creating a database, see the

Informatica 10.4.0 Application Service Guide

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

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}

Rename Saved Search

Table of Contents

Upgrading from Version 10.2 (10.4.0)

Upgrading from Version 10.2 (10.4.0)

Migrating to PostgreSQL

Migrating to PostgreSQL