Upgrade PPM - PostgreSQL (Beta)
You can use the
sh kUpgrade.sh command to upgrade PPM with a PostgreSQL database. This topic provides detailed steps to upgrade PPM with a PostgreSQL database to the latest version.
Note: This feature is available in PPM 10.0.1 and later versions. It is a Beta feature, not field-tested enough. Do not use it in production environment.
To upgrade PPM with a PostgreSQL database:
(Optional but highly recommended) Back up your database and license.conf file.
- Extract the ppm-<PPM version>-upgrade-pg.zip package.
Do either of the following to edit the required parameters.
- Edit the parameter values directly in the ppm.env file in the ppm-<PPM version>-upgrade-pg directory.
exportcommand to set the value for each parameter. For example,
Note: The values set by the
exportcommand override the values set in the ppm.env file.
Make sure these parameter values are the same as what they were before you upgrade PPM with PostSQL datasource. For details about the parameters, see the "Install PPM with PostgreSQL (Beta)" section in this guide.
- Stop the PPM server.
Run the sh kUpgrade.sh command to upgrade the PPM file system and database.
If you want to upgrade the file system only, attach this parameter to the command:
Tip: If you have multiple PPM nodes across multiple physical servers, you need to upgrade the file system on each server but need to upgrade the database only once.
During the upgrade process, PPM generates the logs in the ppm-<PPM version>-upgrade-pg/logs directory. If any problems occur during the upgrade, you can check the log file for troubleshooting.
- Start PPM in your upgraded <PPM_Home> folder.
To make sure the attachments, report logs, and execution logs can still be accessed by the upgraded instance, set the paths of the following parameters to the corresponding folders under the upgraded <PPM_Home> directory: