Can you post the shell script?
On Wed, Feb 25, 2015 at 11:50 AM, Phil Hurvitz <phurv...@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 > phurv...@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" <phurv...@uw.edu >> <mailto:phurv...@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 >> phurv...@u.washington.edu <mailto:phurv...@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 dustym...@gmail.com <mailto:dustym...@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! >> >>
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users