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
[email protected] | 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" <[email protected]
<mailto:[email protected]>> 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
[email protected] <mailto:[email protected]> |
http://gis.washington.edu/__phurvitz
<http://gis.washington.edu/phurvitz>
"What is essential is invisible to the eye." -de Saint-Exupéry
******************************__******************************__**
Bborie Park [email protected] <mailto:[email protected]>
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
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
