<p dir="ltr">The env variables need to be within the environment of the postgres process. How are you starting postgres?</p>
<p dir="ltr">Shell script? Then you should be able to add the variables to that script.</p>
<p dir="ltr">Direct invocation of posrgres on the command line? You need to have the variables before the command</p>
<p dir="ltr">VAR=1 postgres ...</p>
<p dir="ltr">-bborie</p>
<div class="gmail_quote">On Feb 25, 2015 11:40 AM, "Phil Hurvitz" <<a href="mailto:phurvitz@uw.edu">phurvitz@uw.edu</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Thanks Bborie, I built from the tarball rather than using an rpm; does that still mean I should be adding the environment variables to<br>
<br>
/etc/sysconfig/pgsql/<u></u>postgresql<br>
<br>
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.<br>
<br>
I added a slope raster using:<br>
<br>
raster2pgsql -I -C -e -Y -F -d -R -s 2926 ./slope/slope_ps.tif gis.slope | psql osm_test<br>
<br>
I can get metadata (sorry for the ugly text wrapping):<br>
<br>
select rid, (<a href="http://foo.md" target="_blank">foo.md</a>).* from (select rid, st_Metadata(rast) as md from slope) as foo;<br>
rid | upperleftx | upperlefty | width | height | scalex | scaley | skewx | skewy | srid | numbands<br>
-----+------------------+-----<u></u>-------------+-------+--------<u></u>+------------------+----------<u></u>---------+-------+-------+----<u></u>--+----------<br>
1 | 835161.301005914 | 758483.868026069 | 31935 | 34649 | 32.8083333333333 | -32.8083333333333 | 0 | 0 | 2926 | 1<br>
<br>
But cannot access values:<br>
<br>
select st_summarystats(rast) from slope;<br>
ERROR: rt_raster_load_offline_data: Access to offline bands disabled<br>
CONTEXT: SQL function "st_summarystats" statement 1<br>
<br>
select st_value(rast, 1, 1, 1) from slope;<br>
ERROR: rt_raster_load_offline_data: Access to offline bands disabled<br>
<br>
-P.<br>
<br>
******************************<u></u>******************************<u></u>**<br>
Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE<br>
Urban Form Lab | 1107 NE 45th Street, Suite 535 | Box 354802<br>
University of Washington, Seattle, Washington 98195-4802, USA<br>
<a href="mailto:phurvitz@u.washington.edu" target="_blank">phurvitz@u.washington.edu</a> | <a href="http://gis.washington.edu/phurvitz" target="_blank">http://gis.washington.edu/<u></u>phurvitz</a><br>
"What is essential is invisible to the eye." -de Saint-Exupéry<br>
******************************<u></u>******************************<u></u>**<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Bborie Park <a href="mailto:dustymugs@gmail.com" target="_blank">dustymugs@gmail.com</a><br>
Wed Feb 25 10:46:59 PST 2015<br>
</blockquote>
><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Philip,<br>
<br>
POSTGIS_ENABLE_OUTDB_RASTERS=1 is an environment variable not to be in<br>
postgresql.conf.<br>
<br>
The same is true for POSTGIS_GDAL_ENABLED_DRIVERS=<u></u>ENABLE_ALL<br>
<br>
<a href="https://wiki.postgresql.org/wiki/PostgreSQL_on_RedHat_Linux" target="_blank">https://wiki.postgresql.org/<u></u>wiki/PostgreSQL_on_RedHat_<u></u>Linux</a><br>
<br>
Based upon the above, it looks like you should add<br>
<br>
POSTGIS_ENABLE_OUTDB_RASTERS=1<br>
POSTGIS_GDAL_ENABLED_DRIVERS=<u></u>ENABLE_ALL<br>
<br>
to /etc/sysconfig/pgsql/<u></u>postgresql<br>
<br>
The above assumes you're using the packages provided by PostgreSQL.<br>
<br>
<a href="http://www.postgresql.org/download/linux/redhat/" target="_blank">http://www.postgresql.org/<u></u>download/linux/redhat/</a><br>
<br>
-bborie<br>
</blockquote>
<br>
<br>
On 2/25/2015 10:10, Phil Hurvitz wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi all, I am having trouble starting PostGIS with out-db raster support<br>
<br>
In my /usr/local/pgsql/data/<u></u>postgresql.conf file I include the line<br>
<br>
POSTGIS_ENABLE_OUTDB_RASTERS=1<br>
<br>
after which PostGIS won't start (service postgresql start).<br>
<br>
Software is<br>
<br>
postgis_full_version<br>
------------------------------<u></u>------------------------------<u></u>-----------<br>
POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.7.1,<br>
23 September 2009" GDAL="GDAL 1.11.2, released 2015/02/10"<br>
LIBXML="2.7.6" TOPOLOGY RASTER<br>
<br>
<br>
Also PostGIS won't start when I specify<br>
<br>
POSTGIS_GDAL_ENABLED_DRIVERS=<u></u>ENABLE_ALL<br>
<br>
Any help would be appreciated!<br>
<br>
</blockquote>
</blockquote></div>