PostGIS 2.0 on RHEL 5.9

[rhood]

I've successfully installed PostgreSQL 9.2, Pgadmin3 and PostGIS. However, I don't see the postgis extension available.

NOTE: I used the binaries to install

When I type CREATE EXTENSION postgis from PGadmin I get the following:

ERROR: could not open extension control file "/usr/pgsql-9.2/share/extension/postgis.control": No such file or directory SQL state: 58P01

So, how do I get Postges to see PostGIS?

[robe]

rhood,

I presume you are using the yum.postgresql.org packaging. That has to be reported there not here or just discussed on postgis-users mailing list.

Unfortunately I think for lower versions of Redhat, devrim had issues getting rasters included because of other dependencies and the extension isn't included unless postgis was compiled with raster support.

You can install the old fashioned way if you don't need raster support. The .sql files will be in the usual share/contrib/postgis... folder.

[robe]

Here is the related note:

​http://lists.osgeo.org/pipermail/postgis-users/2013-February/036608.html