Procedure to upgrade PostgreSQL v10 to v12 or v13

Description

The default PostgreSQL version offered till pipeline version v3.7 is postgresql v10 and in pipeline v4.0 the default version changed to postgresql v12. This procedure provides the steps to upgrade PostgreSQL version to v12 or the latest available version.

Before you upgrade a production environment, use the procedures in this document to upgrade non-production environment that reproduces your production environment, to test your application to make sure they are compatible with the new version.

Upgrade Procedure

IMPORTANT:

Always backup all of your data before upgrading database version. Use the backup pipeline to perform the backup.

Due to limitation with Redhat based image the in-place upgrade is not possible and the only way to upgrade your database by provisioning the new dataspace with desired version and use the pipeline to import the data from older version database backup.

Here is the upgrade procedure:

1. Provision the new dataspace using the CloudOne selfservice portal.
2. Run the pipeline and choose the desired postgresql version and deploy.

3. Run the pipeline again using the following values.

   1. Choose "Restore" as "Action to perform" dropdown.
   2. Set "Source to restore from" as your old dataspace name
   3. Set "Backup id to restore from" as latest or whatever the backup id you want to use.
   4. Leave the databse version as defaut.
   5. Set "Source and target DB versions match?" as "no".
4. Click Run to start the pipeline.

Click the below image to watch the video