PostgreSQL 17 with PostGIS 3.5.4
G
Gonçalo Coelho
To migrate to PostgreSQL 18, PostGIS must be version 3.5.4+.
Currently, the latest version available in Postgresql (managed by DO) is 3.5.0 (which supports up to PostgreSQL 17). Therefore, it is not possible to update to the new version (postgresql 18) through the Digital Ocean console.
Maurice Arikoglu
Agree, this is gatekeeping postgres 18 for postgis-dependant applications
P
Peter
This issue is particularly confusing since the docs of which extensions are available don't mention that most of the extensions are only available up to Postgres 17 but not Postgres 18, which is currently the default version for new clusters: https://docs.digitalocean.com/products/databases/postgresql/details/supported-extensions/