- Mais recentes
- Mais votos
- Mais comentários
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.
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos