5

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?

7
  • Which version of postgre you use ?
    – user36548
    Commented Sep 3, 2014 at 11:01
  • 1
    What about the result of: SELECT PostGIS_Full_Version(); Commented Sep 3, 2014 at 11:05
  • 1
    It works, apparently I am using PostGIS 2.1.2 with PostgreSQL 9.3.5
    – tkr
    Commented Sep 3, 2014 at 11:42
  • Is the schema always the same? I ask this because the installation of postGIS extension is at schema level. Commented Sep 3, 2014 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
    Commented Sep 3, 2014 at 11:53

1 Answer 1

6

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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