[postgis-users] FW: [ANNOUNCE] PGConf US 2017 - Early Bird Tickets & PostgreSQL Conference Talk Schedule

2017-01-05 Thread Regina Obe
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

Re: [postgis-users] -R rasters fail to \i

2017-01-05 Thread Paolo Cavallini
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

Re: [postgis-users] -R rasters fail to \i

2017-01-05 Thread Regina Obe
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

Re: [postgis-users] -R rasters fail to \i

2017-01-05 Thread Tumasgiu Rossini
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

[postgis-users] -R rasters fail to \i

2017-01-05 Thread Paolo Cavallini
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