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

[Phil Hurvitz]

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!
>