<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Tim,</p>
<p>No problem here with rasters out of db. <br>
</p>
<p>Postgresql needs to know where the raster is and must have access
to it later, when you open it on QGIS.<br>
</p>
<p>Try moving the raster to Postgresql data folder. Run 'SHOW
data_directory;' to know where Postgresql stores the data. Copy
the raster to that folder and try again with the full absolute
path.</p>
<p>Regards,</p>
<p>Jorge Gustavo<br>
</p>
<div class="moz-cite-prefix">On 18/10/21 04:04, tim dunlevie wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAPSUT_xndGYwr=WJ+keJCunfp=4t2yEA4GtnW+j3OOjVtBvEeg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hi all,</div>
<div><br>
</div>
<div>Was wondering if someone has a similar experience.</div>
<div>I'm testing storing raster data in my PostGIS db as an
'out-db' option.</div>
<div>It seems to work via the raster2pgsql command line.</div>
<div>The table is generated and I can see the table thru the
QGIS browser/DB Manager.</div>
<div>However, if I drag/drop onto the map I get nothing.</div>
<div>I can, however, zoom to the extents of the image....but
I get no image appearing.</div>
<div>The image is a geotiff.</div>
<div>In-database option works fine.</div>
<div>I'm using QGIS v3.20.3-Odense with Postgresql 13.4
windows.</div>
<div>Has anyone had success managing their raster data like
this and viewing in QGIS ?</div>
<div><br>
</div>
<div>My command to store out-db image is below:</div>
<div>
<pre class="gmail-lang-sql gmail-s-code-block" style="margin-top:0px;padding:12px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:1.30769;font-size:13px;vertical-align:baseline;box-sizing:inherit;width:auto;max-height:600px;overflow:auto;border-radius:5px"><code class="gmail-hljs gmail-language-sql" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit;background-color:transparent;white-space:inherit">raster2pgsql <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>s <span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">28350</span> <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>C <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>I <span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;box-sizing:inherit">-</span>F “path\[image_name].tif" [schema1].[tablename] -R | psql -h localhost -d spatialDB -U postgres -p 5432</code></pre>
</div>
<div><br>
</div>
<div>thanks</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</body>
</html>