Upgrading the PostgreSQL database server

This procedure describes how to upgrade the PostgreSQL database server to the latest supported version. After you have upgraded Control-M/EM or Control-M/Server, the PostgreSQL database server version remains the same. If you want to upgrade the PostgreSQL database server, perform this procedure.

EXAMPLE: If you upgrade from version 9.0.18 to 9.0.20 the PostgreSQL version (9.5.5) remains the same. However if you install a new Control-M with 9.0.20, the PostgreSQL version is 11.5.

NOTE:

• After you have upgraded the dedicated PostgreSQL database server to PostgreSQL 11, you can no longer downgrade Control-M/EM or Control-M/Server to a version below 9.0.20.
• In a Full installation environment, perform this procedure one time. The Control-M/EM and Control-M/Server PostgreSQL databases are upgraded together.

Before you begin:

• Verify that there is enough disk space to contain an additional PostgreSQL database server.The free space must be greater than the size of the <Control-M_Home>\pgsql directory including an additonal 25%. The upgrade checks if there is enough space and it fails if it is not enough. For example, if the size of the pgsql directory is 1 GB, the upgrade requires at least 1.25 GB of free space.
• Upgrade Control-M/EM or Control-M/Server to version 9.0.20.
• Note that the upgrade requires down time of Control-M. The time for upgrade depends on the size of database. In most scenarios, the upgrade completes in 10 minutes. In a large scale environment it might take up to an hour.

To upgrade the PostgreSQL database server:

1. Navigate to one of the following PostgreSQL server upgrade package locations:
   • UNIX: <cdPath>/Setup_files/TOOLS/pg_server_upgrade.tar.gz
   • Windows: <cdPath>\Setup_files\TOOLS\pg_server_upgrade.zip
2. Copy the package to be parallel to the pgsql directory.

   The pgsql directory is located in one of the following locations:

   • Full Installation and Control-M/Server on UNIX: <Control-M Home>
   • Control-M/EM on UNIX: <Control-M Home>/ctm_em/
   • Full Installation and Control-M/Server on Windows : <Control-M Home>\Control-M Server
   • Control-M/EM on Windows: <Control-M Home>\Control-M EM 9.0.00\Default
3. Do one of the following:
   • UNIX: Type the following commands to open and uncompress:
     1. gunzip pg_server_upgrade.tar.gz
     2. tar -xvf pg_server_upgrade.tar
   • Windows: Extract the pg_server_upgrade.zip.
4. Shut down Control-M/EM or Control-M/Server components (both for Full Install):
5. Navigate to the pg_server_upgrade directory and run one of the following commands:
   • UNIX: PG_Upgrade.sh
   • Windows: PG_Upgrade.bat
6. Follow the on-screen instructions until the upgrade is complete.

   If you want to downgrade to the old PostgreSQL database server version, rename the the pgsql.old.<timestamp> directory to pgsql. The database server is reverted to the existing version before the upgrade. Any changes made to the new PostgreSQL server are not applied to the downgraded PostgreSQL server version.

   After the upgrade, Archive mode is disabled. To perform a hot backup, you need to enable Archive mode and restart the hot backup, as described in Database backup and restore.