[postgis-users] POSTGIS_ENABLE_OUTDB_RASTERS=1: PostGIS won't start (RHEL 6.5)

[Phil Hurvitz]

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
phurvitz at u.washington.edu | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry
**************************************************************


> Bborie Park dustymugs at gmail.com
> 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!
>