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

[Bborie Park]

Can you post the shell script?



On Wed, Feb 25, 2015 at 11:50 AM, Phil Hurvitz <phurvitz at uw.edu> wrote:

> Thanks Bborie, I am starting with a shell script, and have added the env
> vars to that script, but am still unable to access the out-db rasters.
>
> -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
> **************************************************************
>
> On 2/25/2015 11:45, Bborie Park wrote:
>
>> 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
>> <mailto: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 <http://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 <mailto:phurvitz at u.washington.edu> |
>>     http://gis.washington.edu/__phurvitz
>>     <http://gis.washington.edu/phurvitz>
>>     "What is essential is invisible to the eye." -de Saint-Exupéry
>>     ******************************__******************************__**
>>
>>
>>         Bborie Park dustymugs at gmail.com <mailto: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
>>         <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/
>>         <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/04daef4e/attachment.html>