Support for PostgreSQL 12
PostgreSQL 12 has been GA for over 4 months now. Any indication on when it will be supported?
Version 12 contains new features like case-insensitive grouping, better connection security and various improvements that will improve scalability and performance of Large partitioned tables.
From a month ago -- "PostgreSQL 13 Beta 1 Now Available in Amazon RDS Database Preview Environment"...
I think the documentation in this is clear that it is "the current major version on Azure (n) and the two prior major versions (-2)". Microsoft will support not the current major version, but the current major version "on Azure". Which at the moment is horrendously out of date.
Unfortunately I have had to decide today to move off Azure Postgres as it's just too out of date, and there's no indication of an update coming. Not just the major version, but significant major versions of extensions such as PostGIS.
If Azure is going to seriously promote this platform they need to think about timescales for getting major versions ready. As it is, people should not choose Azure for PostgreSQL.
Eric Caron commented
Also worth noting is that Microsoft's commitment on https://docs.microsoft.com/en-us/azure/postgresql/concepts-supported-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)."
PostgreSQL 12 came out October 2019, and it has been available on AWS & GCP for several months. Either adjust your documentation or increase the priority of deploying this.
Jeroen den Hertog commented
It looks like the idea is planned. Does that include PostGIS 3?
Any idea on when we can expect this?
We are specifically looking forward to PG12 with PostGIS 3 extension. It would be great to know what the estimated roadmap is so we can decide if we can wait for the upgrade, or need to manage our own server.
Dave P. commented
It would be nice if PGSQL 12 (including on-by-default JIT extensions) were available as an option.