FYI about next PGConf.
There will be a couple of talks on PostGIS and a lot on PostgreSQL goodness:
TomTom case study using PostGIS -
http://www.pgconf.us/conferences/2017/program/proposals/272
Advanced Spatial Analytics with PL/R and PostGIS -
http://www.pgconf.us/conferences/2017/pr
Il 05/01/2017 15:44, Regina Obe ha scritto:
> You sure your postgres service account can access that file?
>
> rt_band_load_offline_data: Cannot open offline raster:
> /home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf
>
> sounds like a permission error.
>
> One way to confirm it's not the .hdf dr
You sure your postgres service account can access that file?
rt_band_load_offline_data: Cannot open offline raster:
/home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf
sounds like a permission error.
One way to confirm it's not the .hdf driver is to try to load one tile (not
using out of db, in db
Hi,
maybe the postgres user cannot access the offline band ?
Check permissions on /home/paolo/Scrivania/postgis/Dati/dtm .
2017-01-05 11:58 GMT+01:00 Paolo Cavallini :
> Hi all,
> creating an out-of-db raster fails:
> ===
> raster2pgsql -s 3003 -I -M -C -R
> /home/paolo/Scrivania/postgis/Dati/dt
Hi all,
creating an out-of-db raster fails:
===
raster2pgsql -s 3003 -I -M -C -R
/home/paolo/Scrivania/postgis/Dati/dtm/hdr.adf dtm_ext > dtm_ext.sql
less dtm_ext.sql
BEGIN;
CREATE TABLE "dtm_ext" ("rid" serial PRIMARY KEY,"rast" raster);
INSERT INTO "dtm_ext" ("rast") VALUES
(ST_Transform('01000