<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Tim,</p>
<p>Glad it worked. My tip was just to debug the problem.</p>
<p>You don't have to move your data. You just need to make sure the
postgresql daemon has access to that folder, on your file server.
<br>
</p>
<p>Regards,</p>
<p>Jorge Gustavo<br>
</p>
<div class="moz-cite-prefix">On 19/10/21 01:54, tim dunlevie wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAPSUT_w49+-6PJ2mq976VhaRo=SLZy_V7Q2v0LgGO6ATCtKgkg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">thanks Jorge !
<div>So moving the image and loading it again from the
Postgresql data folder worked.</div>
<div>Is it good practise to move/reassign this data directory to
a different path?</div>
<div>Our imagery is stored on a file server, was hoping to
simply 'point' to this area.</div>
<div><br>
</div>
<div>thanks</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Oct 18, 2021 at 10:43
PM Jorge Gustavo Rocha <<a href="mailto:jgr@geomaster.pt"
moz-do-not-send="true" class="moz-txt-link-freetext">jgr@geomaster.pt</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<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>On 18/10/21 04:04, tim dunlevie wrote:<br>
</div>
<blockquote type="cite">
<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 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 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 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 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 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 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 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></fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">Qgis-user@lists.osgeo.org</a>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">Qgis-user@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
</blockquote>
</body>
</html>