Dear all, this is my first post and I hope someone can help me. I cannot access to the information stored in raster mode out-db. Rasters are of the type : generic binary + envi hdr file. I've run the following command: raster2pgsql -R "C:\Users\user\Desktop\1KM*_?? public.tmp | psql -U postgres -d gisdb_2.1
so, I specify the absolute full path of the file. But for example, when I run the query: SELECT ST_Value( rast , 1, 937, 646) tmp from where rid = 1 ; or SELECT St_SummaryStats(rast) from tmp where rid=1; the error message is as follows: ERROR : rt_band_load_offline_data : Can not open raster offline: C:\Users\user\Desktop\1KM_2006_01_16_094500_ch31_T_TB If I run the query: select st_width (rast) , st_height (rast) tmp from where rid = 1 ; I get the right information, so I think the metadata are stored correctly. I haven't problem if the same raster file is stored in mode in-db. The work environment is: " POSTGIS =" 2.1.0 r11822 " GEOS =" 3.4.2 - CAPI - 1.8.2 r0 " PROJ =" Rel 4.8.0 , March 6, 2012 " = GDAL " GDAL 1.10.0 , released 24/04/2013 " libxml =" 2.7.8 " LIBJSON =" UNKNOWN " RASTER " and Windows 7 Professional 64 -bit and Postgres 9.2 _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
