Supported PostgreSQL database 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 version is 11.4. Refer to the PostgreSQL documentation to learn more about improvements and fixes in this minor version.

PostgreSQL version 10

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

PostgreSQL version 9.6

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

PostgreSQL version 9.5

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

Managing upgrades

Azure Database for PostgreSQL automatically manages minor version upgrades.

Automatic major version upgrade is not supported. For example, there is not an automatic upgrade from PostgreSQL 9.5 to PostgreSQL 9.6. To upgrade to the next major version, create a database dump and restore to a server that was created with the new engine version.

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 version upgrade. Version 10 to 11 is a major version upgrade.

Next steps

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