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. _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users