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

[Bborie Park]

The env variables need to be within the environment of the postgres
process. How are you starting postgres?

Shell script? Then you should be able to add the variables to that script.

Direct invocation of posrgres on the command line? You need to have the
variables before the command

VAR=1 postgres ...

-bborie
On Feb 25, 2015 11:40 AM, "Phil Hurvitz" <phurvitz at uw.edu> wrote:

> 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!
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150225/46b8f4fb/attachment.html>