- 최신
- 최다 투표
- 가장 많은 댓글
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:
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.
관련 콘텐츠
- AWS 공식업데이트됨 2년 전