Supported PostgreSQL major versions

Microsoft aims to support n-2 versions of the PostgreSQL engine in Azure Database for PostgreSQL - Single Server. The versions would be the current major version on Azure (n) and the two prior major versions (-2).

Azure Database for PostgreSQL currently supports the following major versions:

PostgreSQL version 11

The current minor release is 11.6. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 10

The current minor release is 10.11. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 9.6

The current minor release is 9.6.16. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor release.

PostgreSQL version 9.5

The current minor release is 9.5.20. Refer to the PostgreSQL documentation to learn about improvements and fixes in this minor release.

Managing upgrades

The PostgreSQL project regularly issues minor releases to fix reported bugs. Azure Database for PostgreSQL automatically patches servers with minor releases during the service's monthly deployments.

Automatic in-place upgrades for major versions are not supported. To upgrade to the next major version, you can

Version syntax

Before PostgreSQL version 10, the PostgreSQL versioning policy considered a major version upgrade to be an increase in the first or second number. For example, 9.5 to 9.6 was considered a major version upgrade. As of version 10, only a change in the first number is considered a major version upgrade. For example, 10.0 to 10.1 is a minor release upgrade. Version 10 to 11 is a major version upgrade.

Next steps

For information on supported PostgreSQL extensions, see the extensions document.