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.
W
Whitney Jutzin
Merged in a post:
Request to enable PostGIS extension on PostgreSQL cluster
Zalvisya Inovasi Teknologi
Hello,
I would like to request the PostGIS extension to be enabled on my
PostgreSQL managed database cluster.
PostgreSQL Version: 18.2
According to Aiven documentation, PostGIS should be available:
Thank you.
T
Thierry Parent
Any news on whether or not PostGIS will be made available with a rough timeline? We started our environments on v18 assuming it would be available as it's probably one of the most used extensions out there.
M
Mike Battistella
I have the same problem too. I also need Postgis in my Postgress 18.3 cluster
M
Manuel Becker
I'm having the same issue. I just created a new Postgres18 managed DB because the upgrade didn't work, and now I realize that I can't run CREATE EXTENSION postgis;
Is there any ETA on when this will be re-added?
Morten Kals
I'm having the same issue
E
Elias Witt
Any update on this? This is keeping us from running postgres 18 ):
M
Manuel Becker
Elias Witt Me too and therefore I tried to create a new DB with Postgres 18 but just realized that managed Postgres 18 is not supporting Postgis right now at all, so the update for Postgres 17 won't remove the blocker.
Alexander Graf
Just ran into the same problem. Especially confusing is that the docs now explicitly mention "PostgreSQL 17 and newer".
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/