<div dir="ltr"><div>Hi Tumasgiu,<br><br></div>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.<br><br>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.<br><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Apr 19, 2017 at 4:41 PM, Tumasgiu Rossini <span dir="ltr"><<a href="mailto:rossini.t@gmail.com" target="_blank">rossini.t@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hi,<br><br></div>What is the format of your rasters ?<br></div>With your precedents messages in mind, I guess that the format is Mr.SID,<br></div><div>can you confirm that ?<br></div><div>(if so, then it means that you have managed your first postgis build, so congrats !)<br><br></div><div>It's important to give as much as detail as possible if you want help.<br> <br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">2017-04-18 15:43 GMT+02:00 Osahon Oduware <span dir="ltr"><<a href="mailto:osahon.gis@gmail.com" target="_blank">osahon.gis@gmail.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><div>Hi All,</div><div><br></div><div>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. </div><div><br></div><div>I would be glad if someone could help me to resolve this.</div></div>
<br></div></div>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/postgis-users</a><br></blockquote></div><br></div>
<br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>