[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Enabling output GDAL Driver
From: Saulteau Don <sault.don () gmail ! com>
Date: 2022-03-26 16:20:23
Message-ID: CAJo0jfP_gw8rFZ=G+aOrHLb+5cCMCAkf2-91YNRssnbf_k0BgA () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Maybe see if the correct environment variable also need to be set?
POSTGIS_GDAL_ENABLED_DRIVERS
Specifies a list of GDAL drivers to enable (rather than skip) By default
all drivers are disabled. Example value: "GTiff PNG JPEG"
POSTGIS_ENABLE_OUTDB_RASTERS
Enables read support for out-db raster bands if set to 1. By default out-db
raster bands reading is disabled.
That's taken from the security notes at
https://postgis.net/2014/05/19/postgis-2.0.6_and_2.1.3/
saultdon
On Sat., Mar. 26, 2022, 08:02 David Haynes, <haynesd2@gmail.com> wrote:
> Hello List,
>
> 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.
>
> ERROR: rt_raster_to_gdal: Could not load the output GDAL driver
>
> 2022-03-26 10:32:24,110 ERROR [jdbc.custom] - ERROR: rt_raster_to_gdal:
> Could not load the output GDAL driver
> Where: PL/pgSQL function st_astiff(raster,text[],integer) line 24 at
> RETURN
> org.postgresql.util.PSQLException: ERROR: rt_raster_to_gdal: Could not
> load the output GDAL driver
>
> Overstack suggested this, but it hasn't worked. Do I have to recompile?
>
> SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
[Attachment #5 (text/html)]
<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:i \
nherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:1.30769;font-s \
ize: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-a \
lign: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;vert \
ical-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>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic