4

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?

  • Which version of postgre you use ? – user36548 Sep 3 '14 at 11:01
  • 1
    What about the result of: SELECT PostGIS_Full_Version(); – MickyInTheSky Sep 3 '14 at 11:05
  • 1
    It works, apparently I am using PostGIS 2.1.2 with PostgreSQL 9.3.5 – tkr Sep 3 '14 at 11:42
  • Is the schema always the same? I ask this because the installation of postGIS extension is at schema level. – MickyInTheSky Sep 3 '14 at 11:52
  • Actually the reason I need the PostGIS extension to show up as an installed extension is because I want to change it's schema. It currently resides completely in "public", I would like to move it to its own schema, but I cant, since "ALTER EXTENSION ..." doesn't work. I could install PostGIS in a new schema and delete everything by "hand" in "public", but then my geometry columns in my tables are lost. – tkr Sep 3 '14 at 11:53
5

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)!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.