[Qgis-user] Trouble with reading raster data from PostGIS

[Jorge Gustavo Rocha]

Hi,

You registered the raster out of the DB. You need to provide the full
path for the raster, not just name.tif.

Regards,

Jorge Gustavo

Às 16:46 de 01/07/19, Marks, Constant escreveu:
>
> Can anyone help me with getting my system setup correctly for adding
> raster layers from a Postgresgl10/PostFIS3 server setup on an RHEL7
> server.  
>
>  
>
> I can connect to the database and it shows up in my console but when I
> go to add a referenced raster layer from the Database Manager I get an
> error like this in the  Rendering Log:
>
>  
>
> /smodr_5d83364e_b1aa_431d_b8af_c1b1c625710e ::
> PostGISRasterRasterBand::IRasterIO(): ERROR:
> rt_band_load_offline_data: Cannot open offline raster://name.tif/
>
>  
>
> In the Layers dialog the extents show as 1.79769e+308/-1.79769e+308.
>
>  
>
> I can resolve this if I do not use the –R flag when importing the
> raster into pg using the rater2pgsql function.  I expect this has
> something to do with the postgis.enable_outdb_raster variable but
> changing this with SET postgis.enable_outdb_raster TO True does not help.
>
> Any ideas?
>
>  
>
> *Constant Marks
> *Research Assistant | Computer Science and Engineering
> University of North Texas
>
> Office: Discovery Parks F216 
> e: constant.marks at unt.edu <mailto:constant.marks at unt.edu>
> t: (303) 482 7292 <tel:482%207292>
>
>  
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Logo*   Geomaster, LDA*
  *VENHA DESCOBRIR O CAMINHO DO OPEN SOURCE CONNOSC**O

*
 
Avenida Barros e Soares
N.º 423, 4715-214 Braga
VAT/NIF510 906 109
Phone  +351 253 680 323
Site       geomaster.pt <http://geomaster.pt>
GPS       41.53322, -8.41929
	
------------------------------------------------------------------------
	 
Jorge Gustavo Rocha
CTO

Mobile  +351 910 333 888
Email    jgr at geomaster.pt


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190701/845cd5bc/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cropped-geomaster300x300-1.png
Type: image/png
Size: 33896 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190701/845cd5bc/attachment-0001.png>