Ensure that your Microsoft Azure PostgreSQL database servers are using the latest major version of PostgreSQL database in order to receive new or enhanced features and the most recent security fixes.
This rule resolution is part of the Conformity Security & Compliance tool for Azure.
efficiency
The PostgreSQL open-source project regularly issues new releases that can be available to Microsoft Azure cloud customers. By upgrading your Azure PostgreSQL database servers with the new version of PostgreSQL, you will introduce new software features, fix reported bugs through security patches, and provide better compatibility with other applications and services. For example, PostgreSQL 11 represents a major version that includes a variety of improvements associated with partitioning, parallelism, stored procedures, covering indexes and other important performance enhancements.
Audit
To determine if your Azure PostgreSQL servers are using the latest major version of PostgreSQL database, perform the following actions:
Remediation / Resolution
Automated upgrade to a major PostgreSQL engine version is not currently supported. For example, there is not an automatic upgrade from PostgreSQL 9.5 to PostgreSQL version 9.6. To upgrade your Azure PostgreSQL server to the latest major version of the PostgreSQL database, you have to re-create the existing server, export a database dump, and restore it to the PostgreSQL server with the new engine version. To implement the rule remediation process, perform the following actions:
References
- Azure Official Documentation
- Database
- Supported PostgreSQL major versions
- Limits in Azure Database for PostgreSQL - Single Server
- Migrate your PostgreSQL database using dump and restore
- Azure Command Line Interface (CLI) Documentation
- az postgres server list
- az postgres server show
- az postgres server create
- az postgres server delete
Unlock the Remediation Steps
Free 30-day Trial
Automatically audit your configurations with Conformity
and gain access to our cloud security platform.
You are auditing:
Check for PostgreSQL Major Version
Risk Level: Low