PostGIS 3.0.3 incompatible with PostgreSQL 12.17.

1

Hi all, we recently had an incident where our PostgreSQL DB server in RDS was upgraded to 12.17 from 12.14 (through routine RDS maintenance). At the time it was running the PostGIS extension version 3.0.3. A consequence of this was that any call to the PostGIS function ST_ClusterKMeans caused a Sig 11 fault that put the DB into recovery mode and terminated all existing connections. We were able to resolve the issue once we'd identified the cause by upgrading the PostGIS extension to 3.4, but it caused over 24 hours of downtime.

Peter
已提问 3 个月前115 查看次数
2 回答
2

PostGIS 3.0.3 is recommended for use with PostgreSQL 13.1 and GEOS 3.8.1. Meanwhile, PostGIS 3.4 is compatible with PostgreSQL versions 12 through 16, and requires GEOS 3.6 or newer. It is advisable to keep this compatibility in mind, especially since others may encounter similar challenges during routine RDS maintenance.

Resources:

profile picture
专家
已回答 3 个月前
2

The challenge we faced was that when we originally created the PostgreSQL instance (12.7), it shipped with PostGIS 3.0.3 (https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-12x).

Unfortunately, RDS eventually migrated PostgreSQL to 12.17, but PostGIS extension migrations were not automatic, so it wasn't until it reached 12.17 that it failed.

Lesson learned, keep extensions up to date, but it was still an unexpected failure.

Peter
已回答 3 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则