Azure Database for PostgreSQL Gains Pre-Upgrade Validation Checks to Identify Issues Before Version Upgrades

Microsoft has introduced support for Pre‑Upgrade Validation Checks in public preview for Azure Database for PostgreSQL. This new feature allows IT teams to catch and fix potential issues before performing version upgrades in enterprise environments.

Azure Database for PostgreSQL is a managed cloud service provided by Microsoft Azure that lets users run PostgreSQL databases without handling the underlying servers or maintenance tasks. It automates operations such as updates, backups, scaling, and security, while still giving developers a flexible and reliable environment to build and manage applications using PostgreSQL.

According to Microsoft, one of the biggest challenges with PostgreSQL upgrades is that issues (such as compatibility problems, unsupported extensions, or configuration gaps) are often discovered only after the upgrade process has already started. This reactive approach can lead to failed upgrades, unexpected downtime, and rushed troubleshooting during critical maintenance windows, which makes the overall process risky and unpredictable for production systems.

“This new capability lets you validate upgrade readiness before starting the actual major version upgrade, helping you identify and resolve blockers early. With Pre-Upgrade Validation Checks, you can run upgrade checks independently, review actionable results, fix issues, and re-run validation until your server is ready. This shifts upgrade troubleshooting from the upgrade window to a proactive pre-flight step,” Microsoft explained.

What do the validation checks actually analyze?

The validation process checks both Azure-specific requirements and PostgreSQL compatibility to ensure the system is ready for an upgrade. It reviews factors such as overall system readiness (including configuration, server status, and available storage) along with extension compatibility to identify any unsupported or sensitive extensions.

It also examines database dependencies and objects like replication slots, triggers, and PostGIS settings, while performing engine-level checks using PostgreSQL’s built-in pg_upgrade –check tool. If any issues are detected, this feature provides clear, actionable recommendations to help resolve them before proceeding with the upgrade.

How to enable Pre-Upgrade Validation Checks in Azure Portal?

Microsoft notes that the Pre-Upgrade Validation Checks feature is currently available in public preview for Azure Database for PostgreSQL flexible server. Administrators can get started by opening their flexible server in the Azure portal, navigating to Upgrade, choosing their target PostgreSQL version, and then selecting Validate only.

These checks help identify potential problems early, as well as reduce the chances of failed upgrade attempts and minimize unexpected disruptions. This capability helps improve planning and predictability, which makes production upgrades smoother and more reliable.