<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
font-size:10.0pt;
font-family:"Courier New";}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Yah the data directory is less likely to have screwed up permissions that the postgres account can’t access. So I would go with Jorge’s idea.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>That said I would think that having permission with r r r should do the trick and the fact you can get a directory listing suggests the postgres process can at least read the list of files.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The only thing I can think of is maybe something is locking those files in some write mode preventing any other process from reading. I’m assuming you are done with loading so shouldn’t be that.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>To rule out postgis raster is at fault, maybe try restarting the service and do that pg_stat_file check again immediately after restarting.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regarding your question about “Why is it offline? It's there.”<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>It’s offline because it’s not in your database. Out-db / offline are equivalent terminology in postgis raster. We should probably change that terminology to out-db cause offline means not reachable in other contexts and just confusing. I think calling it out-db is a lot clearer.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> <b>On Behalf Of </b>Jorge Gustavo Rocha via postgis-users<br><b>Sent:</b> Wednesday, December 6, 2023 5:25 PM<br><b>To:</b> postgis-users@lists.osgeo.org<br><b>Cc:</b> Jorge Gustavo Rocha <jgr@di.uminho.pt><br><b>Subject:</b> Re: [postgis-users] out db: not able to query the raster<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Hi Andrea,<o:p></o:p></p><p>I always put the raster somewhere below Postgresql data_directory.<o:p></o:p></p><p>psql<br>show data_directory;<o:p></o:p></p><p>I hope it helps.<o:p></o:p></p><p>Saluti,<o:p></o:p></p><p>Jorge<o:p></o:p></p><div><p class=MsoNormal>On 04/12/23 22:23, andy via postgis-users wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal>Hi, <o:p></o:p></p><div><p class=MsoNormal>if I run "SELECT (ST_BandMetaData(rast)).* FROM rasters_outdb LIMIT 1;", in the field path I have "/directory_docker/ou_s6_01_01_stack.tif"<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>If I run "ls -l /directory_docker/ou_s6_01_01_stack.tif" I have<br><br>-rwxr--r-- 1 1000 1000 2100227 Dec 4 08:32 /directory_docker/ou_s6_01_01_stack.tif<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>But when I run "SELECT ST_Value(rast, 1, 1) FROM rasters_outdb;" I get <br><br>ERROR: rt_band_load_offline_data: Cannot open offline raster: /directory_docker/ou_s6_01_01_stack.tif<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Why is it offline? It's there.<o:p></o:p></p></div><div><p class=MsoNormal>I'm using postgis/postgis:16-master<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I have created the sql file to load it in postgres, running<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>raster2pgsql -I -C -M -F -t auto -R /directory_docker/ou_s6_01_01_stack.tif public.rasters_outdb<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>How to read the pixel values using a PG SQL query?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thank you<br clear=all><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal><span class=gmailsignatureprefix>-- </span><o:p></o:p></p><div><div><div><div><div><div><div><div><div><div><div><div><div><p class=MsoNormal><span style='font-size:12.0pt'>___________________</span><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Andrea Borruso<br>website: <a href="https://medium.com/tantotanto" target="_blank">https://medium.com/tantotanto</a><br>38° 7' 48" N, 13° 21' 9" E, EPSG:4326<br><span style='font-size:12.0pt'>___________________</span><br><br>"cercare e saper riconoscere chi e cosa,<br> in mezzo all’inferno, non è inferno, <br>e farlo durare, e dargli spazio"<br><br>Italo Calvino<o:p></o:p></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><p class=MsoNormal><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>postgis-users mailing list<o:p></o:p></pre><pre><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><o:p></o:p></pre><pre><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><o:p></o:p></pre></blockquote></div></div></body></html>