postgis is missing in list of extensions after installation

[hansgso]

I have installed postgis 2.1.3 from source on debian 7.6 with postgres 9.3.

Installation was successful and postgis is working:

SELECT version()

' '	postgis_full_version();

"PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit POSTGIS="2.1.3 r12547" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.8.0" LIBJSON="UNKNOWN" TOPOLOG (…)"

I notice that in PGadmin III under database/extensions postgis is not listed, but it is in the view pg_available_extensions.

When I try to install pgrouting I got this message:

ERROR: required extension "postgis" is not installed SQL state: 42704.

It looks like something is missing during the installation of postgis to register it.

Hans

[robe]

did you install with

CREATE EXTENSION postgis;

If you didn't you don't have postgis installed as an extension.

[robe]

I'm going to close this out. This is a common mistake people make. Just because you have postgis installed does not mean you have it installed as an extension.

If that is not your issue, feel free to reopen.