Attempting to preview PostGIS external rasters crashes QGIS

[qgib]

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 12133
Affected QGIS version: 2.6.0
Redmine category:db_manager

---

Loading it does not crash, but it does not show anything meaningful either.

[qgib]

Author Name: Martin Dobias (@wonder-sk)

---

Do you mean that external raster == stored out of DB?

Could you please check the backtrace - the crash may be inside GDAL, I think it does not support out of DB rasters yet.

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

Yes, I mean imported through the -R option.
Are you sure GDAL does not support them?

[qgib]

Author Name: Martin Dobias (@wonder-sk)

---

I'm not 100% sure but judging it's not supported from:

• GDAL ticket: http://trac.osgeo.org/gdal/ticket/3234
• GDAL source: http://trac.osgeo.org/gdal/browser/trunk/gdal/frmts/postgisraster/postgisrastertilerasterband.cpp#L144

[qgib]

Author Name: Even Rouault (@rouault)

---

I confirm out-db PostGIS raster are not supported yet in GDAL. After the fix in GDAL trunk (http://trac.osgeo.org/gdal/changeset/28530 that was a fix for a regression in trunk only and should put GDAL in the state of GDAL 1.11), I cannot get crashes however, just blank images with error messages in the console. Paolo mentionned to me he uses GDAL 1.10.1 : there have been significant rework in GDAL 1.11 in the PostGIS raster driver that might explain GDAL 1.11 and later being at least more robust when ingesting out-db raster.

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

I can't produce a crash either - only black images. So it's a dependency issue (GDAL complains @error 1: This raster has outdb storage. This feature isn't still available@).

---

• resolution was changed from to up/downstream
• status_id was changed from Open to Closed