[GIS] Installed PostGIS extension not listed for database

installationpostgis

I have a PostgreSQL database with the PostGIS extension enabled.

I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions.

However, PostGIS is not listed in the installed extensions section, and thus I can't alter it nor uninstall it.

If I try

CREATE EXTENSION postgis;

it tells me that PostGIS is already installed, and that I should uninstall it first. However

DROP EXTENSION postgis CASCADE;

tells me that no PostGIS extension is installed.

What can I do? Any ideas?

Best Answer

I got it, the problem was, that I had an old Postgres/PostGIS install, from a time where EXTENSIONS where not supported (I didn't create the database).

That's why it didn't show up in the extensions, after following the "HARD UPGRADE" guide it worked (just remember to use extensions for the newdb)!

Related Question