Thanks Bborie, I built from the tarball rather than using an rpm; does
that still mean I should be adding the environment variables to
/etc/sysconfig/pgsql/postgresql
So for overkill I added the env vars to that file as well as to the init
script, restarted PostgreSQL, and it seems I still cannot access the
out-db raster.
I added a slope raster using:
raster2pgsql -I -C -e -Y -F -d -R -s 2926 ./slope/slope_ps.tif
gis.slope | psql osm_test
I can get metadata (sorry for the ugly text wrapping):
select rid, (foo.md).* from (select rid, st_Metadata(rast) as md from
slope) as foo;
rid | upperleftx | upperlefty | width | height |
scalex | scaley | skewx | skewy | srid | numbands
-----+------------------+------------------+-------+--------+------------------+-------------------+-------+-------+------+----------
1 | 835161.301005914 | 758483.868026069 | 31935 | 34649 |
32.8083333333333 | -32.8083333333333 | 0 | 0 | 2926 | 1
But cannot access values:
select st_summarystats(rast) from slope;
ERROR: rt_raster_load_offline_data: Access to offline bands disabled
CONTEXT: SQL function "st_summarystats" statement 1
select st_value(rast, 1, 1, 1) from slope;
ERROR: rt_raster_load_offline_data: Access to offline bands disabled
-P.
**************************************************************
Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE
Urban Form Lab | 1107 NE 45th Street, Suite 535 | Box 354802
University of Washington, Seattle, Washington 98195-4802, USA
[email protected] | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry
**************************************************************
Bborie Park [email protected]
Wed Feb 25 10:46:59 PST 2015
>
Philip,
POSTGIS_ENABLE_OUTDB_RASTERS=1 is an environment variable not to be in
postgresql.conf.
The same is true for POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL
https://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux
Based upon the above, it looks like you should add
POSTGIS_ENABLE_OUTDB_RASTERS=1
POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL
to /etc/sysconfig/pgsql/postgresql
The above assumes you're using the packages provided by PostgreSQL.
http://www.postgresql.org/download/linux/redhat/
-bborie
On 2/25/2015 10:10, Phil Hurvitz wrote:
Hi all, I am having trouble starting PostGIS with out-db raster support
In my /usr/local/pgsql/data/postgresql.conf file I include the line
POSTGIS_ENABLE_OUTDB_RASTERS=1
after which PostGIS won't start (service postgresql start).
Software is
postgis_full_version
-----------------------------------------------------------------------
POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.7.1,
23 September 2009" GDAL="GDAL 1.11.2, released 2015/02/10"
LIBXML="2.7.6" TOPOLOGY RASTER
Also PostGIS won't start when I specify
POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL
Any help would be appreciated!
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
