Run pre-upgrade validation checks (Preview)

This article describes how to run Pre-Upgrade Validation Checks (PVC) for Azure Database for PostgreSQL flexible server.

Pre-Upgrade Validation Checks (PVC) help identify compatibility issues and upgrade blockers before starting a major version upgrade by validating upgrade readiness independently from the actual upgrade operation.

Note

Pre-Upgrade Validation Checks validate upgrade readiness only. They don't perform the actual major version upgrade.

Prerequisites

Before running Pre-Upgrade Validation Checks:

• Ensure the server is in the Ready state.
• Ensure the target PostgreSQL major version is supported by Azure Database for PostgreSQL flexible server.
• Review the supported upgrade paths and limitations documented in Major version upgrades in Azure Database for PostgreSQL flexible server.

Run pre-upgrade validation checks

Using the Azure portal:

1. Select the Azure Database for PostgreSQL flexible server instance that you want to validate.

2. From the resource menu, select Overview.

3. Select Upgrade.

4. In the Upgrade pane, select the target PostgreSQL version.

5. Select Validate Only.

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

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

3. After validation completes:

   • If no blocking issues are detected, validation completes successfully.

• If blocking issues are detected, review the reported errors and remediate them before retrying validation.

1. Select Operation details to review validation progress and results.

Validation checks don't restart the server or initiate the major version upgrade process.

Review validation results

After Pre-Upgrade Validation Checks complete, review the validation findings to identify any upgrade blocking issues.

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.

The downloaded report includes:

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

Review detailed validation logs

Pre-Upgrade Validation Checks also generate upgrade validation logs that can be downloaded from the Server logs page.

Note

To download validation logs, Server Logs must be enabled on the server. For more information, see Configure capture of PostgreSQL server logs and major version 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

• Major version upgrade