Edit

Run upgrade validation checks (Preview)

This article describes how to run upgrade validation checks for Azure Database for PostgreSQL flexible server.

Upgrade validation checks help you identify compatibility problems and upgrade blockers before you start a major version upgrade. They validate upgrade readiness independently from the actual upgrade operation.

Note

Upgrade validation checks validate upgrade readiness only. They don't perform the actual major version upgrade.

Prerequisites

Before running upgrade validation checks, review the supported upgrade paths and limitations documented in Major version upgrades in Azure Database for PostgreSQL.

Steps to run upgrade validation checks

Using the Azure portal:

  1. From the resource menu, select Overview.

  2. The server status must be Ready for the Upgrade button to be enabled.

    Screenshot showing where in the Overview page you can find the status of the server.

  3. Select Upgrade.

    Screenshot showing the Upgrade button through which you can initiate the major version upgrade of an Azure Database for PostgreSQL flexible server.

  4. Expand PostgreSQL version to upgrade, and select the major version for which you want to validate the upgrade.

    Screenshot showing the Upgrade pane, from where you can select the major version to which you want to upgrade.

  5. For Action, select Validate and upgrade to run the validation rules and, if they all pass, it immediately upgrades the server to the selected target version. It warns you about the consequences of initiating the upgrade.

    Screenshot showing the Action option configured as Validate only.

  6. Select Start.

    Screenshot showing the Start button, to initiate the upgrade.

  7. The validation process starts and performs upgrade readiness checks against the server.

  8. Wait for the validation operation to complete. Keep the validation status pane open to monitor progress and review validation results.

  9. After validation completes, if no blocking issues are detected, you can download the successful report as a CSV file or you can select the Upgrade button to proceed with the upgrade of the server to the selected target version.

    Screenshot showing successful completion of upgrade validation checks.

  10. After validation completes, if blocking issues are detected, review the reported errors and fix them before retrying validation.

    Screenshot showing failed upgrade validation checks with remediation guidance for blocking issues.

Review validation results

After the upgrade validation checks finish, review the validation findings to identify any upgrade blocking problems.

Review validation findings in the portal

The validation results pane displays:

  • Validation checks that succeeded
  • Validation checks that failed
  • Detailed descriptions and remediation guidance for failed checks

You can also download the validation results as a .csv file for offline review or sharing with your operations team.

Screenshot showing the Download .csv button for in the Pre-upgrade validation pane.

The downloaded report includes:

  • Validation check name
  • Validation result
  • Error details
  • Remediation recommendations for blocking problems

Review detailed validation logs

Upgrade validation checks also generate upgrade validation logs that you can download from the Server logs page.

Note

To download validation logs, you must enable server logs on the server. For more information, see Download PostgreSQL and upgrade logs.

To access validation logs:

  1. In the Azure portal, go to your Azure Database for PostgreSQL flexible server instance.

  2. Select Server logs under the Monitoring section.

  3. Locate the generated pg_upgrade log files.

  4. Download the log files for detailed validation output and troubleshooting information.

Related content

  • Last updated on