Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
Serious bug in Azure Database for PostgreSQL Flexible Server PostGIS extension
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 80%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Martin Daly
0
Reputation points
The Azure Database for PostgreSQL Flexible Server instances that we have were upgraded over the weekend (on Saturday 16th, as far as I can tell).
The upgrade has introduced a new version of the PostGIS extension that we rely on. You can see from this page that all versions of the PostgreSQL database in Azure now use PostGIS version 3.5.2:
https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-versions#postgis
PostGIS versions 3.5.0, 3.5.1 and 3.5.2 all have a serious bug that can, and is, affecting our users. We reported this bug to the PostGIS developers in December 2024, and it was fixed in March 2025:
https://trac.osgeo.org/postgis/ticket/5819
The first version with the fix is PostGIS 3.5.3 (released in May 2025):
https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.5.3/NEWS
See this entry from the NEWS, with matching ticket number: "- #5819, Support longer names in estimated extent (Paul Ramsey)"
This bug is serious, and the supported version of PostGIS needs to be upgraded to 3.5.3 (or downgraded to 3.4.x) as a matter of urgency.How can we make this happen?
Azure Database for PostgreSQL
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator2025-08-25T07:12:46.01+00:00 Martin Daly Thanks for reaching out. I understand that you are facing an issue with the PostGIS extension version in your Azure Database for PostgreSQL Flexible Server instances.
Based on the response from the product group team, they are planning to fix this issue in an upcoming maintenance update, but there is no specific ETA yet. In the meantime, they suggest potentially downgrading to an earlier version, with the awareness that the next maintenance release may require further handling.
do let me know incase of further queries, I would be happy to assist you.
-
Martin Daly 0 Reputation points
2025-08-26T10:12:51.83+00:00 Downgrading is not supported https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
-
VRISHABHANATH PATIL 85 Reputation points Microsoft External Staff Moderator
2025-08-29T06:10:19.58+00:00 Hi @Martin Daly
Thank you for getting in touch and sharing your feedback. We've already escalated this matter to the Product Team for further review and will keep you updated as soon as we receive any new information.
We sincerely appreciate your patience and understanding in this matter.
Regards,
Vrishabh
Sign in to comment
Sign in to answer