Prerequisites for PostgreSQL database installation and upgrade
Before you install or upgrade the PostgreSQL database, ensure that the following prerequisites are met:
•You have sufficient free disk space. Informatica recommends that you have a minimum free disk space that is twice the size of the Data folder in the following directory:
•The user who runs scripts to install or upgrade the PostgreSQL database must have read, write, and modify permissions for the folders within the following directory:
•Stop the PostgreSQL database and Process Server. If the Secure Agent is associated with an advanced cluster, you must stop Process Server on all nodes.
Note: This step is required when you run the db_upgrade script with the upgrade command line option. However, it is optional when you run the db_upgrade script with the check command line option. Therefore, you can run the db_upgrade script with the check command line option without any downtime.
•On Linux operating systems, the operating system user's locale must use the UTF-8 encoding to match the encoding of the PostgreSQL database. Otherwise, Process Server fails to start.
•On Linux operating systems, verify that the GNU C (GLIBC) library file is of version 2.14 or later. To find the version number, run the following command: ldd --version