<div dir="auto"><div>Maybe see if the correct environment variable also need to be set?</div><div dir="auto"><br></div><div dir="auto"><br><div dir="auto">POSTGIS_GDAL_ENABLED_DRIVERS</div><div dir="auto">Specifies a list of GDAL drivers to enable (rather than skip) By default all drivers are disabled. Example value: “GTiff PNG JPEG”</div><div dir="auto"><br></div><div dir="auto">POSTGIS_ENABLE_OUTDB_RASTERS</div><div dir="auto">Enables read support for out-db raster bands if set to 1. By default out-db raster bands reading is disabled.</div><div dir="auto"><br></div><div dir="auto">That's taken from the security notes at <a href="https://postgis.net/2014/05/19/postgis-2.0.6_and_2.1.3/">https://postgis.net/2014/05/19/postgis-2.0.6_and_2.1.3/</a></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto"><br></div><div dir="auto">saultdon</div><div dir="auto"><br></div><div class="gmail_quote" dir="auto"><div dir="ltr" class="gmail_attr">On Sat., Mar. 26, 2022, 08:02 David Haynes, <<a href="mailto:haynesd2@gmail.com" target="_blank" rel="noreferrer">haynesd2@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello List,<div><br></div><div>Running into an error running a 3rd party application GeoServer (2.16) to visualize rasters stored in PostgreSQL. It seems my PostgreSQL DB has not enabled the output GDAL driver.</div><div><br></div><div>ERROR: rt_raster_to_gdal: Could not load the output GDAL driver<br></div><div><br></div><div>2022-03-26 10:32:24,110 ERROR [jdbc.custom] - ERROR: rt_raster_to_gdal: Could not load the output GDAL driver<br>  Where: PL/pgSQL function st_astiff(raster,text[],integer) line 24 at RETURN<br>org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not load the output GDAL driver<br></div><div><br></div><div>Overstack suggested this, but it hasn't worked. Do I have to recompile?</div><div><pre style="margin-top:0px;margin-bottom: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"><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">SET</span> postgis.gdal_enabled_drivers <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> <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">'ENABLE_ALL'</span>;</code></pre></div><div><br></div></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" rel="noreferrer noreferrer" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div></div></div>