- Newest
- Most votes
- Most comments
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.
Relevant content
- Accepted Answerasked a year ago
- asked 8 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 months ago