[postgis-users] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

[Osahon Oduware]

Hi Tumasgiu,

Sorry, for not updating you. Yes, I followed up on your suggestion and
Regina, Adrian, and some others assisted me in building PostGIS with a
MrSID-enabled GDAL. My Out-DB rasters are in the MrSID format.

This raster file exist on the filesystem and when it is loaded directly
into QGIS it displays the image (aerial photo). Also, when the same file is
stored in PostGIS as a raster (IN-DB), it can be viewed in QGIS (using the
DB Manager tool). However, when I reference the same file as an OUT-DB
raster in PostGIS (in this case only the metadata of the raster and the
filepath to the raster file is stored), an attempt to view it in QGIS
(using the DB Manager tool) results in a black image being displayed
instead of the aerial photo.


On Wed, Apr 19, 2017 at 4:41 PM, Tumasgiu Rossini <rossini.t at gmail.com>
wrote:

> Hi,
>
> What is the format of your rasters ?
> With your precedents messages in mind, I guess that the format is Mr.SID,
> can you confirm that ?
> (if so, then it means that you have managed your first postgis build, so
> congrats !)
>
> It's important to give as much as detail as possible if you want help.
>
>
> 2017-04-18 15:43 GMT+02:00 Osahon Oduware <osahon.gis at gmail.com>:
>
>> Hi All,
>>
>> I have an out-db raster on PostGIS which I tried to load in QGIS (v
>> 2.14.12-Essen) utilizing the DB Manager to establish a connection. I could
>> view the raster table, but when I try to "Add to canvas" it displays a
>> black screen instead of the raster image.
>>
>> I would be glad if someone could help me to resolve this.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170419/277a063c/attachment.html>