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 versions:

PostgreSQL Version 11.2

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

Note

PostgreSQL version 11 is available in preview. Support for creation using the Azure portal is being rolled out and may not yet be available in your region. You can use the Azure CLI to create a Postgres 11 server in any region. For example, az postgres server create -g group -n server -u username -p password -l westeurope --sku-name GP_Gen5_2 --version 11.

PostgreSQL Version 10.7

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

PostgreSQL Version 9.6.12

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

PostgreSQL Version 9.5.16

Refer to the PostgreSQL documentation to learn about improvements and fixes in this minor version.

Managing updates and upgrades

Azure Database for PostgreSQL automatically manages minor version patches. Currently, major version upgrade is not supported. For example, upgrading from PostgreSQL 9.5 to PostgreSQL 9.6 is not supported. If you would like to upgrade to the next major version, create a database dump and restore it to a server that was created with the new engine version.

Note that prior to 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, and 10 to 11 is a major version upgrade).

Next steps

For information about the support of different PostgreSQL extensions, see PostgreSQL Extensions.