Edit

Supported versions of PostgreSQL with Azure Arc-enabled PostgreSQL server

  • Article
  • 2 minutes to read

The list of supported versions evolves over time as we progress on ensuring parity with Postgres managed services in Azure PaaS. Today, the major versions that is supported is PostgreSQL 14.

Note

As a preview feature, the technology presented in this article is subject to Supplemental Terms of Use for Microsoft Azure Previews.

The latest updates are available in the release notes.

How to choose between versions?

It is recommend you look at what versions your applications have been designed for and what are the capabilities of each of the versions. To learn more, read about each version on the official PostgreSQL site:

How to create a particular version in Azure Arc-enabled PostgreSQL server?

At creation time, you have the possibility to indicate what version to create by passing the --engine-version parameter. If you do not indicate a version information, by default, a server group of PostgreSQL version 14 will be created.

Note that there is only one PostgreSQL Custom Resource Definition (CRD) in your Kubernetes cluster no matter what versions we support. For example, run the following command:

kubectl get crds

It will return an output like:

NAME                                                             CREATED AT
dags.sql.arcdata.microsoft.com                                   2021-10-12T23:53:40Z
datacontrollers.arcdata.microsoft.com                            2021-10-13T01:00:27Z
exporttasks.tasks.arcdata.microsoft.com                          2021-10-12T23:53:39Z
healthstates.azmon.container.insights                            2021-10-12T19:04:44Z
monitors.arcdata.microsoft.com                                   2021-10-13T01:00:26Z
postgresqls.arcdata.microsoft.com                                2021-10-12T23:53:37Z
sqlmanagedinstancerestoretasks.tasks.sql.arcdata.microsoft.com   2021-10-12T23:53:38Z
sqlmanagedinstances.sql.arcdata.microsoft.com                    2021-10-12T23:53:37Z

In this example, this output indicates there are one CRD related to PostgreSQL: postgresqls.arcdata.microsoft.com, shortname postgresqls. The CRD is not a PostgreSQL server. The presence of a CRD is not an indication that you have - or not - created a server. The CRD is an indication of what kind of resources can be created in the Kubernetes cluster.

How can I be notified when other versions are available?

Come back and read this article. It will be updated as appropriate.

Next steps: