[postgis-users] rtpostgis.sql is missing, postgis 2.0.2 r10789

Gery gamejihou at hotmail.com
Sat Dec 15 15:01:09 PST 2012


Hello,

I've been checking things after installing postgis2.0.2, and noticed
something, rtpostgis.sql is missing, and also the GDAL version.  After
running this command I get:

[code]
SELECT postgis_full_version();
NOTICE:  Function postgis_gdal_version() not found.  Is raster support
enabled and rtpostgis.sql installed?
NOTICE:  Function postgis_topology_scripts_installed() not found. Is
topology support enabled and topology.sql installed?
NOTICE:  Function postgis_raster_scripts_installed() not found. Is raster
support enabled and rtpostgis.sql installed?
NOTICE:  Function postgis_raster_lib_version() not found. Is raster support
enabled and rtpostgis.sql installed?
                                               postgis_full_version                                               
------------------------------------------------------------------------------------------------------------------
 POSTGIS="2.0.2 r10789" GEOS="3.3.6-CAPI-1.7.6" PROJ="Rel. 4.8.0, 6 March
2012" LIBXML="2.6.26" LIBJSON="UNKNOWN"
[/code]

Also, if I run "CREATE EXTENSION postgis" in one of my dbs (user: postgres),
I get:
ERROR:  could not open extension control file
"/usr/pgsql-9.2/share/extension/postgis.control": No such file or directory

I looked for all these sql files and only rtpostgis.sql isn't located where
it should be:

[code]
$ d /usr/pgsql-9.2/share/contrib/postgis-2.0/
total 5.0M
-rw-r--r-- 1 root root  14k Dec 10 10:04 topology_comments.sql
-rw-r--r-- 1 root root  69k Dec 10 10:04 raster_comments.sql
-rw-r--r-- 1 root root  65k Dec 10 10:04 postgis_comments.sql
-rw-r--r-- 1 root root  11k Dec 10 10:04 uninstall_topology.sql
-rw-r--r-- 1 root root  37k Dec 10 10:04 uninstall_postgis.sql
-rw-r--r-- 1 root root  15k Dec 10 10:04 uninstall_legacy.sql
-rw-r--r-- 1 root root 270k Dec 10 10:04 topology_upgrade_20_minor.sql
-rw-r--r-- 1 root root 271k Dec 10 10:04 topology.sql
-rw-r--r-- 1 root root 3.6M Dec 10 10:04 spatial_ref_sys.sql
-rw-r--r-- 1 root root 150k Dec 10 10:04 postgis_upgrade_20_minor.sql
-rw-r--r-- 1 root root 195k Dec 10 10:04 postgis.sql
-rwxr-xr-x 1 root root 147k Dec 10 10:04 postgis_restore.pl*
-rw-r--r-- 1 root root  55k Dec 10 10:04 legacy.sql
-rw-r--r-- 1 root root 2.6k Dec 10 10:04 legacy_minimal.sql
-rw-r--r-- 1 root root 1.3k Dec 10 10:04 legacy_gist.sql
drwxr-xr-x 3 root root 4.1k Dec 14 00:32 ../
drwxr-xr-x 2 root root 4.1k Dec 15 23:00 ./
[/code]

I think that GDAL is the problem. It seems to me that python doesn't find it
in its path. This package comes from the ELGIS repository (RPM). Since
everything I installed is RPM, I don't know how to point things, perhaps
this is the trick to let GDAL (assuming this is the problem) working with
PostGIS 2 to get rtpostgis.sql. In fact calling import gdal in python
console gives a deprecated warning, with import osgeo.gdal, the warning
dissapears, I think this is the problem. Any idea is appreciated, thanks in
advance.

Best regards,

PS. my setting:
[1] OS:
rhel5 32-bit (python2.4)
in .bashrc: 
export PATH=$PATH:/sbin:/usr/sbin:.
export LD_LIBRARY_PATH=/usr/lib
export GDAL_LIBRARY_PATH=/usr/lib

[2] RPM and repo:
gdal-perl-1.8.0-4.el5.elgis
gdal-static-1.8.0-4.el5.elgis
gdal-ruby-1.8.0-4.el5.elgis
gdal-doc-1.8.0-4.el5.elgis
gdal-python-1.8.0-4.el5.elgis
gdal-1.8.0-4.el5.elgis
gdal-devel-1.8.0-4.el5.elgis
gdal-java-1.8.0-4.el5.elgis
proj-nad-4.8.0-2.rhel5
proj-debuginfo-4.8.0-2.rhel5
proj-4.8.0-2.rhel5
proj-devel-4.8.0-2.rhel5
proj-epsg-4.8.0-2.rhel5
geos-debuginfo-3.3.6-1.rhel5
geos-3.3.6-1.rhel5
geos-devel-3.3.6-1.rhel5
geos-python-3.3.6-1.rhel5
geos-ruby-3.3.6-1.rhel5
postgis2_92-devel-2.0.2-1.rhel5
postgis2_92-debuginfo-2.0.2-1.rhel5
postgis2_92-2.0.2-1.rhel5
postgis2_92-utils-2.0.2-1.rhel5
postgis2_92-docs-2.0.2-1.rhel5
postgresql92-server-9.2.2-1PGDG.rhel5
postgresql92-contrib-9.2.2-1PGDG.rhel5
postgresql92-odbc-09.01.0200-1PGDG.rhel5
postgresql92-jdbc-debuginfo-9.2.1000-1PGDG.rhel5
postgresql92-libs-9.2.2-1PGDG.rhel5
postgresql92-debuginfo-9.2.2-1PGDG.rhel5
postgresql92-docs-9.2.2-1PGDG.rhel5
postgresql92-odbc-debuginfo-09.01.0200-1PGDG.rhel5
postgresql92-9.2.2-1PGDG.rhel5
postgresql92-test-9.2.2-1PGDG.rhel5
postgresql92-devel-9.2.2-1PGDG.rhel5
postgresql92-jdbc-9.2.1000-1PGDG.rhel5
postgresql92-plpython-9.2.2-1PGDG.rhel5
postgresql92-plperl-9.2.2-1PGDG.rhel5
postgresql92-pltcl-9.2.2-1PGDG.rhel5
json-c-devel-0.10-2.el5
json-c-0.10-2.el5
libxml2-2.6.26-2.1.2.8
libxml2-devel-2.6.26-2.1.2.8
libxml2-python-2.6.26-2.1.2.8



--
View this message in context: http://postgis.17.n6.nabble.com/rtpostgis-sql-is-missing-postgis-2-0-2-r10789-tp5002068.html
Sent from the PostGIS - User mailing list archive at Nabble.com.


More information about the postgis-users mailing list