PowerCenter
- PowerCenter 10.5.6
- All Products
To securely connect to PostgreSQL for the PowerCenter repository, set the[PCRS_DB_SERVICE_NAME] host=Database host IP port=Database port dbname=PowerCenter Repository Service database service name
$ export PGSERVICEFILE; PGSERVICEFILE=<InstallationDirectory>/pg_service.conf
$ setenv PGSERVICEFILE <InstallationDirectory>/pg_service.conf
$ export PGHOME; PGHOME=/usr/pgsql-10
$ setenv PGHOME /usr/pgsql-10
$ export PATH; PATH=${PATH}:${PGHOME}
$ setenv PATH ${PGHOME}:${PATH}