This guide provides the steps to upgrade an existing PostgreSQL installation to version 17.7.1. These actions must be performed on the machine where your PostgreSQL database is installed.
Before You Begin: Prerequisites
Before starting the upgrade, it is critical to prepare your environment to prevent data loss and ensure a smooth transition.
-
Stop CloudM Services:
- Log in to the machine hosting your PostgreSQL installation.
- First, verify that no migrations are currently running within the CloudM application.
- Once confirmed, stop the CloudM Primary Migration Service.
-
Back Up Your Database:
- You must create a complete backup of your PostgreSQL databases before proceeding.
- For detailed instructions, please see our guide: How to Back Up PostgreSQL Databases (Using PowerShell)
Upgrade Procedure
Follow these steps to perform the in-place upgrade of the PostgreSQL software.
-
Download the Installer:
- Download the PostgreSQL 17.7.1 installer from the official CloudM storage link:
- https://storage.googleapis.com/cloudmigrator-install/v10/postgresql-17.7-1-windows-x64.exe
-
Run the Installer:
- Run the downloaded
postgresql-17.7-1-windows-x64.exefile. - Follow the on-screen instructions provided by the installer wizard to complete the upgrade. The installer should detect your existing installation and upgrade it.
- Run the downloaded
Post-Upgrade Verification
Once the installer has finished, you must verify that the upgrade was successful and that the CloudM application is fully functional.
-
Restart CloudM Services:
- Start the CloudM Primary Migration Service that you stopped during the prerequisite phase.
-
Verify Application Functionality:
- Open the CloudM application.
- Navigate through the interface (e.g., check the dashboard, view configuration settings) to confirm that the application is loading and operating correctly.
Troubleshooting and Rollback
While the upgrade process is typically seamless, you should be prepared for any unexpected issues.
- If Something Goes Wrong: If the CloudM application fails to start or you observe database connection errors, you may need to roll back the changes.
-
Restore from Backup: As a precautionary measure, be prepared to restore your databases from the backup you created in the prerequisite step.
- For detailed instructions, please see our guide: How to Restore PostgreSQL Databases (Using PowerShell)
- Contact Support: If you encounter any issues during or after the upgrade, please contact the CloudM Support team for assistance.