Supported PostgreSQL database versions

Microsoft aims to support n-2 versions of the PostgreSQL engine in the Azure Database for PostgreSQL service. 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 10.5

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

PostgreSQL Version 9.6.10

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

PostgreSQL Version 9.5.14

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.

Next steps

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