<div dir="ltr"><div dir="ltr"><div dir="ltr">Hi, Regina,<div><br></div><div>Thank you very much for the information!</div><div>Now, I can understand clearly where this problem is coming from.</div><div>It's really helpful for us!</div><div><br></div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">Requires<br>1) Create a new database with both postgis and postgis_raster installed.<br>2) Backup your old database that has postgis_raster installed and restore on top of this new database</blockquote></div><div>This is just what I am thinking. Fortunately, we only use one database with postgis_raster, we can work in this way.</div><div>But it's actually very painful, the volume of that database is so huge, it may take a lot of time to restore...</div><div><br></div><div>Thank you for the script which can uninstall raster functions from the database. I was also wondering how I can delete old postgis_raster functions from those databases...I could use your attached script!</div><div><br></div><div>Have a nice weekend!</div><div>Jin</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">2020年5月29日(金) 21:54 Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div class="gmail-m_-2698229643303687711WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Added dev to the thread, since we might be able to change something in next release to fix.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">You could try running the below – that is essentially where the script is failing, but I suspect this will fail as well.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">CREATE EXTENSION postgis_raster FROM unpackaged;<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I think the part of the script that is triggering their error is this part of the raster unpackaged script.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">CREATE TEMPORARY TABLE _postgis_upgrade_info AS WITH versions AS (<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> SELECT '3.1'::text as upgraded,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> postgis_raster_scripts_installed() as installed<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">) SELECT<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> upgraded as scripts_upgraded,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> installed as scripts_installed,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> substring(upgraded from '([0-9]*)\.')::int * 100 +<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> substring(upgraded from '[0-9]*\.([0-9]*)\.')::int<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> as version_to_num,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> substring(installed from '([0-9]*)\.')::int * 100 +<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> substring(installed from '[0-9]*\.([0-9]*)\.')::int<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> as version_from_num,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> installed ~ 'dev|alpha|beta'<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> as version_from_isdev<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> FROM versions;<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">That’s used to pull the VERSION number of current running version.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">We (PostGIS Development Group) could change that to a declare variable at the top since everthing is wrapped in a big DO anyway, without too much fuss. <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Given it’s only Amazon having this issue, it may not be worth doing it from our end.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Even if we do it on our end, who knows how long it would take Amazon to apply the fix and unpackaged won’t be available in PG13 so won’t work moving forward for anyone.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">The other way to work around this issue is more painful.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Requires <u></u><u></u></span></p><p class="gmail-m_-2698229643303687711MsoListParagraph"><u></u><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>1)<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-stretch:normal;font-size:7pt;line-height:normal;font-family:"Times New Roman""> </span></span></span><u></u><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Create a new database with both postgis and postgis_raster installed.<u></u><u></u></span></p><p class="gmail-m_-2698229643303687711MsoListParagraph"><u></u><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><span>2)<span style="font-style:normal;font-variant-caps:normal;font-weight:normal;font-stretch:normal;font-size:7pt;line-height:normal;font-family:"Times New Roman""> </span></span></span><u></u><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Backup your old database that has postgis_raster installed and restore on top of this new database<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">For your databases that don’t use postgis raster, you could just run the uninstall_rtpostgis.sql script<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Which I have attached.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hope that helps,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Regina<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><div style="border-style:none none none solid;border-left-width:1.5pt;border-left-color:blue;padding:0in 0in 0in 4pt"><div><div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> Regina Obe [mailto:<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>] <br><b>Sent:</b> Friday, May 29, 2020 8:16 AM<br><b>To:</b> 'PostGIS Users Discussion' <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> RE: [postgis-users] Failed to upgrade PostGIS Raster from 2.2.5 to 3.0 on RDS<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">This looks like an issue specific to PostGIS on Amazon. <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">The only work arounds I can think of such as first upgrading the PostGIS raster with the script approach would not work on Amazon because of the security restrictions they have put in place.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I think this is something they need to fix on their end.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Regina <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><div style="border-style:none none none solid;border-left-width:1.5pt;border-left-color:blue;padding:0in 0in 0in 4pt"><div><div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">mailto:postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Jin Igarashi<br><b>Sent:</b> Friday, May 29, 2020 12:01 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> [postgis-users] Failed to upgrade PostGIS Raster from 2.2.5 to 3.0 on RDS<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">We are currently using PostgreSQL 9.6.11 / PostGIS 2.3.7 on RDS.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Because AWS started to support pg12/PostGIS3.0 recently, we are trying to upgrade our PostGIS database to 3.0.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Then, I am facing a problem that could not upgrade postgis_raster to 3.0.0. I need some help if possible.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">My upgrading procedures are as follows.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">1. I upgrade postgis from 2.2.5 to 2.3.7 on the current RDS database by following SQL.<u></u><u></u></p></div><div><pre style="background-color:rgb(246,248,250);box-sizing:border-box;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;overflow:auto;background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">ALTER EXTENSION postgis UPDATE;</span></code><span style="font-family:Consolas;color:rgb(36,41,46)"><u></u><u></u></span></pre></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">2. I upgrade PostgreSQL from 9.6.11 to 9.6.17 by AWS management console<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">3. Then, I upgrade PostGIS from 2.3.7 to 2.5.2 by using following SQL.<u></u><u></u></p></div><div><pre style="background-color:rgb(246,248,250);box-sizing:border-box;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;overflow:auto;background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">ALTER EXTENSION postgis UPDATE TO '2.5.2';<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.gdal_datapath' is already set and cannot be changed until you reconnect<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect</span></code><u></u><u></u></pre></div><div><p class="MsoNormal">There are some warnings appeared, but I think it's not problems...I continued.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">4. I upgraded PostgreSQL from 9.6.17 to 12.2 by AWS management console<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">5. I upgraded PostGIS from 2.5.2 to 3.0.0 by following SQL.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><pre style="background-color:rgb(246,248,250);box-sizing:border-box;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;overflow:auto;background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">ALTER EXTENSION postgis UPDATE TO '3.0.0';<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: unpackaging raster<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: PostGIS Raster functionality has been unpackaged<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">HINT: type `SELECT postgis_extensions_upgrade(); to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">ALTER EXTENSION</span></code><u></u><u></u></pre></div><div><p class="MsoNormal">Then, I tried as follow;<u></u><u></u></p></div><div><pre style="background-color:rgb(246,248,250);box-sizing:border-box;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;overflow:auto;background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">SELECT postgis_extensions_upgrade();<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in"><u></u> <u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">NOTICE: Packaging extension postgis_raster<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.gdal_datapath' is already set and cannot be changed until you reconnect<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">WARNING: 'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">ERROR: cannot create temporary table within security-restricted operation<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">CONTEXT: SQL statement "CREATE EXTENSION postgis_raster FROM unpackaged"<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">PL/pgSQL function postgis_extensions_upgrade() line 48 at EXECUTE</span></code><u></u><u></u></pre></div><div><p class="MsoNormal">After running "SELECT postgis_extensions_upgrade();", its error appeared and I could not upgrade postgis_raster from 2.5.2 to 3.0.0. <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Current PostGIS version is like below. <u></u><u></u></p></div><div><pre style="background-color:rgb(246,248,250);box-sizing:border-box;border-top-left-radius:3px;border-top-right-radius:3px;border-bottom-right-radius:3px;border-bottom-left-radius:3px;overflow:auto;background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">SELECT postgis_full_version();<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">postgis_full_version <u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in"> POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 " PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.4, released 2020/01/08" LIBXML="2.9.1" LIBJSON="0.13.1" LIBPROTOBUF="1.3.2" WAGYU="0.4.3 (Internal)" RASTER (raster lib from "2.5.2 r17328" need upgrade) [UNPACKAGED!] (raster procs from "2.5.2 r17328" need upgrade)<u></u><u></u></span></code></pre><pre style="background-color:rgb(246,248,250);background-position:initial initial;background-repeat:initial initial"><code><span style="font-family:Consolas;color:rgb(36,41,46);border:1pt none windowtext;padding:0in">(1 row)</span></code><u></u><u></u></pre></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Although most of our databases do not use raster functions, a database is using raster functions. I found upgraded databases on PostGIS3.0 is working very well apart from a database which is using postgis_raster.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I tried to search the solution on how to upgrade postgis_raster, but I could not find any information about it. It is maybe some particular problem of RDS, I don't know...<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I found a information on AWS Developer Forum, someone faced the same error..but there is no solution on the site.<u></u><u></u></p></div><div><p class="MsoNormal"><a href="https://forums.aws.amazon.com/thread.jspa?messageID=938665" target="_blank">https://forums.aws.amazon.com/thread.jspa?messageID=938665</a><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Does anyone have a similar experience of this error? If so, I want to get some advice on how to solve it..<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Best Regards,<u></u><u></u></p></div><div><p class="MsoNormal">Jin Igarashi<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div>