[QGIS-Developer] Reading out-of-db PostgreSQL Raster

[Paolo Cavallini]

yes; I tend not to pollute system dirs with user data, so I usually put
(or link) everything pg-related in a dedicated dir accessible by
postgres. I just forgot to do it in this new machine.
Thanks.

Il 06/11/19 10:32, Jorge Gustavo Rocha ha scritto:
> Hi Paolo,
> 
> Nice to know you found out the problem. The easiest option to store
> out-of-db rasters can be under Postgresql's data_directory. All users
> should be able to read files from there.
> 
> # show data_directory;
>        data_directory
> -----------------------------
>  /var/lib/postgresql/11/main
> 
> Regards,
> 
> Jorge
> 
> 
> Às 07:37 de 06/11/19, Paolo Cavallini escreveu:
>> /me stupid: postgresql did not have read access to the file.
>> sorry for the noise
>>
>> Il 06/11/19 08:18, Paolo Cavallini ha scritto:
>>> Hi Jorge,
>>>
>>> Il 05/11/19 21:34, Jorge Gustavo Rocha ha scritto:
>>>
>>>> If you have GDAL >= 2.4, it should work. Can you check your GDAL version?
>>>
>>> 2.4.2+dfsg-2
>>>
>>>> Do you also have overviews/pyramids? The overviews should work, because
>>>> they are in db. Only the original raster is out-of-db.
>>>
>>> sure, all "normal" rasters, incluging the pyramids, are correctly shown.
>>>
>>> thanks for the feedback.
>>>
>>>> Às 20:24 de 05/11/19, Paolo Cavallini escreveu:
>>>>> Hi all,
>>>>> loading PostGIS rasters from the browser works very well, thanks Ale!
>>>>> However, those loaded with the -R option (out of db rasters) throw an error:
>>>>>
>>>>> Warning: Logged warning: RasterIO error:
>>>>> PostGISRasterRasterBand::IRasterIO(): ERROR:  rt_band_load_offline_data:
>>>>> Cannot open offline raster:
>>>>> /home/paolo/Documents/Didattica/Corsi_Formazione_Faunalia/PostGIS/data/dtm_nord.tif
>>>>>
>>>>> I have enabled out-of-db rasters:
>>>>>
>>>>>  POSTGIS_ENABLE_OUTDB_RASTERS=1
>>>>>  POSTGIS_GDAL_ENABLED_DRIVERS=ENABLE_ALL
>>>>>
>>>>> The same data are readable from psql
>>>>> select * from dtm_ext ;
>>>>> ┌─────┬───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
>>>>> │ rid │
>>>>>
>>>>> ├─────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
>>>>> │   1 │ 01000001...
>>>>>
>>>>> Is this a known limitation, or do I need some additional config?
>>>>>
>>>>> Thanks.
>>>>>
>>>>
>>>> J. Gustavo
>>>>
>>>
>>
> 
> J. Gustavo
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/