<div dir="ltr">Hi Regina,<div><br></div><div>I have one more question.<br><div><br></div><div>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>Platform:<br>Windows Server 2019 Standard<br>PostgreSQL 11.17 x64<br>PostGIS 3.2.3<br>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>Problem:<br>-- I installed Postgis 3.2.3 for PostgreSQL 11 and I was able to upgrade the postgis extension to 3.2.3 <br>-- the raster extension is still 2.5.2 and just for testing I dropped the raster type <br>-- now I cannot upgrade postgis_raster<br>-- I can restore a backup but I wonder if there is a way to fix this and be able to do the raster extension upgrade<br>-- database has no raster data, hence the goal is to upgrade the postgis_raster extension and then drop the postgis_raster extension<br>-- see details below.<br>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>-- The postgis extension was updated fine to PostGIS 3.2.3<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" <br>LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" (core procs from ""3.2.2 3.2.2"" need upgrade) <== !!! 3.2.2 NEED UPGRADE !!! <br>RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"<br><br>-- ALTER EXTENSION postgis UPDATE;<br><br>Query returned successfully in 599 msec.<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" <br>LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" <br>RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"<br><br>-- ALTER EXTENSION postgis UPDATE;<br><br>NOTICE: version "3.2.3" of extension "postgis" is already installed<br>ALTER EXTENSION<br><br>Query returned successfully in 160 msec. <br><br>-- SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';<br><br>"name" "default_version" "installed_version" "comment"<br>"postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions"<br>"postgis_raster" "3.2.3" <null> "PostGIS raster types and functions"<br><br>-- DROP TYPE IF EXISTS public.raster CASCADE; <== DROPPED THE RASTER TYPE WITH CASCADE OPTION !!! I KNOW SHOULD NOT HAVE DONE THAT BUT THIS IS JUST A TEST !!!<br><br>-- SELECT postgis_extensions_upgrade();<br><br>"postgis_extensions_upgrade"<br>"Upgrade completed, run SELECT postgis_full_version(); for details"<br><br>NOTICE: Extension postgis_raster is not available or not packagable for some reason<br>NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason<br>NOTICE: Extension postgis_topology is not available or not packagable for some reason<br>NOTICE: Extension postgis_tiger_geocoder is not available or not packagable for some reason<br><br>Successfully run. Total query runtime: 129 msec.<br>1 rows affected.<br><br>-- CREATE EXTENSION postgis_raster;<br><br>ERROR: PostGIS Raster is already installed in schema 'public'<br>CONTEXT: PL/pgSQL function inline_code_block line 10 at RAISE<br>SQL state: P0001<br><br>-- ALTER EXTENSION postgis_raster UPDATE;<br><br>ERROR: extension "postgis_raster" does not exist<br>SQL state: 42704<br><br>-- DROP EXTENSION postgis_raster;<br><br>ERROR: extension "postgis_raster" does not exist<br>SQL state: 42704<br><br>----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br><br></div><div>Thanks for the assistance.</div><div><br></div><div>Marcelo Marques</div><div>Principal Product Engineer | Esri | <a href="http://www.esri.com">www.esri.com</a></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Aug 31, 2022 at 11:58 AM Marcelo Marques <<a href="mailto:marcelosmbr@gmail.com">marcelosmbr@gmail.com</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 dir="ltr">oh my. sorry. forgot the '%' thanks for catching that. Thanks a lot. :)<div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Aug 31, 2022 at 11:25 AM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</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><div lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Marcelo,<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 it’s your query and below behavior you describe as I understand it seems correct.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">And your output is correct:<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">"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 3.4.3, released 2022/04/22 GDAL_DATA not found"" <br>LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" RASTER"<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)">Instead of:<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">SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';<u></u><u></u></p><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)">Should be:<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">SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">And then the postgis_raster should show along with postgis_topology and postgis_sfcgap and postgis_tiger_geocoder.<u></u><u></u></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-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid 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 [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Marcelo Marques<br><b>Sent:</b> Wednesday, August 31, 2022 2:03 PM<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] extension "postgis_raster" has no installation script nor update path for version "unpackaged"<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal"><br>-- Yes, I have Postgis 3.2.2 for PostgreSQL 11 installed and it already contain a file named "postgis--unpackaged--3.2.2.sql" under "C:\Program Files\PostgreSQL\11\share\extension"<br><br>C:\Program Files\PostgreSQL\11\share\extension>dir postgis--unpackaged*.*<br><br> Directory of C:\Program Files\PostgreSQL\11\share\extension<br><br>03/11/2019 12:12 PM 1,475,393 postgis--unpackaged--2.5.2.sql<br>07/30/2022 12:49 AM 1,068,869 postgis--unpackaged--3.2.2.sql<br>08/30/2022 04:14 PM 21 postgis--unpackaged.sql<br><br>-- I compared the file C:\Program Files\PostgreSQL\11\share\extension\postgis--unpackaged--3.2.2.sql on my server <br>-- with the one from <a href="https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql" target="_blank">https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql</a> <br>-- and they are identical.<br>-- and still fails to upgrade.<br><br>-- SELECT postgis_extensions_upgrade();<br><br>NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason<br>NOTICE: Packaging extension postgis_raster<br><br>ERROR: extension "postgis_raster" has no installation script nor update path for version "unpackaged"<br>CONTEXT: SQL statement "CREATE EXTENSION postgis_raster SCHEMA public VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.2""<br>PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE<br>SQL state: 22023<br><br>-- I followed you suggestion and installed Postgis 3.2.3 for PostgreSQL 11<br>-- I checked and PostGIS 3.2.3 has the empty file "C:\Program Files\PostgreSQL\11\share\extension\postgis--unpackaged.sql" <br>-- This file just has text "-- Nothing to do here"<br><br>C:\Program Files\PostgreSQL\11\share\extension>dir postgis--unpa*.*<br><br> Directory of C:\Program Files\PostgreSQL\11\share\extension<br><br>03/11/2019 12:12 PM 1,475,393 postgis--unpackaged--2.5.2.sql<br>08/19/2022 04:24 PM 1,465,258 postgis--unpackaged--3.2.3.sql<br>08/30/2022 04:14 PM 21 postgis--unpackaged.sql<br><br>-- I was able to upgrade the postgis extension <br>-- and upgrade the raster extension and then <br>-- remove the raster extension and <br>-- if I want I can reinstall postgis_raster extension<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" <br>LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" (core procs from ""3.2.2 3.2.2"" need upgrade) <== !!! 3.2.2 NEED UPGRADE !!! <br>RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"<br><br>-- ALTER EXTENSION postgis UPDATE;<br><br>Query returned successfully in 599 msec.<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" <br>LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" <br>RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"<br><br>-- ALTER EXTENSION postgis UPDATE;<br><br>NOTICE: version "3.2.3" of extension "postgis" is already installed<br>ALTER EXTENSION<br><br>Query returned successfully in 160 msec.<br><br>-- SELECT postgis_extensions_upgrade();<br><br>"Upgrade completed, run SELECT postgis_full_version(); for details"<br><br>NOTICE: Updating extension postgis from 3.2.2 to 3.2.3<br>NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason<br>NOTICE: Packaging extension postgis_raster<br>WARNING: 'postgis.gdal_datapath' is already set and cannot be changed until you reconnect<br>WARNING: 'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect<br>WARNING: 'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect<br>NOTICE: Extension postgis_topology is not available or not packagable for some reason<br>NOTICE: Extension postgis_tiger_geocoder is not available or not packagable for some reason<br><br>Successfully run. Total query runtime: 1 secs 884 msec.<br>1 rows affected.<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>GDAL=""GDAL 3.4.3, released 2022/04/22 GDAL_DATA not found"" <br>LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" RASTER"<br><br>-- SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';<br><br>"postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions"<br><br>-- CREATE EXTENSION postgis_raster;<br><br>ERROR: extension "postgis_raster" already exists<br>SQL state: 42710<br><br>-- NOTE: if postgis_raster already exists then pg_available_extensions should have showed that, seems another bug to fix !!!<br><br>-- DROP EXTENSION postgis_raster;<br><br>DROP EXTENSION<br><br>Query returned successfully in 125 msec.<br><br>-- SELECT postgis_full_version();<br><br>"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <br>LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"""<br><br>--NOTE: RASTER EXTENSION REMOVED !!!<br><br>-- Try to install postgis_raster extension<br><br>-- CREATE EXTENSION postgis_raster;<br><br>CREATE EXTENSION<br><br>Query returned successfully in 252 msec.<br><br>- SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';<br><br>"postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions"<br><br>--NOTE: pg_available_extensions still does not show postgis_raster but in pgAdmin when expand the "Extensions" I can see "postgis" and "postgis_raster".<br><br>-- DROP EXTENSION postgis_raster;<br><br>DROP EXTENSION<br><br>Query returned successfully in 125 msec.<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I appreciated your assistance.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks,<u></u><u></u></p></div><div><p class="MsoNormal">Marcelo<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Tue, Aug 30, 2022 at 8:42 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I guess my attachment was too big.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Here is a link to it if you need it, <a href="https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql" target="_blank">https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql</a></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">but if you are running a patched PostgreSQL 11, you’ll really need to be using the PostGIS 3.2.3 install which you can get from application stackbuilder or <a href="https://download.osgeo.org/postgis/windows/pg11/" target="_blank">https://download.osgeo.org/postgis/windows/pg11/</a></span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hope that helps,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Regina</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid 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> Tuesday, August 30, 2022 8:00 PM<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] extension "postgis_raster" has no installation script nor update path for version "unpackaged"</span><u></u><u></u></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)">Attached is the one for 3.2.2</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">But that is in my artifacts so should have already been installed by your setup. Do you have the attached file in your share/extension folder?</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid 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 [</span><a href="mailto:lr@pcorp.us" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">mailto:lr@pcorp.us</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif">] <br><b>Sent:</b> Tuesday, August 30, 2022 7:56 PM<br><b>To:</b> 'PostGIS Users Discussion' <</span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">postgis-users@lists.osgeo.org</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif">><br><b>Subject:</b> RE: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"</span><u></u><u></u></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)">Oh you are running 3.2.2 and not 3.2.3. I know 3.2.3 has this file</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">postgis_raster--unpackaged--3.2.3.sql</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">which is what you are missing.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Can you install 3.2.3? Then once you install the binaries, run again and it should work.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid 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 [</span><a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">mailto:postgis-users-bounces@lists.osgeo.org</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif">] <b>On Behalf Of </b>Marcelo Marques<br><b>Sent:</b> Tuesday, August 30, 2022 7:39 PM<br><b>To:</b> PostGIS Users Discussion <</span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">postgis-users@lists.osgeo.org</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif">><br><b>Subject:</b> Re: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"</span><u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><div><p class="MsoNormal">Hello Regina,<u></u><u></u></p><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">I tried but the upgrade still failed, see below.<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--create an empty file named "postgis--unpackaged.sql" in your share/extension folder of your PostgreSQL install.<br>--This file just has text<br>-- Nothing to do here<br>--C:\Program Files\PostgreSQL\11\share\extension folder<br>--And then try your upgrade again.<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--SELECT postgis_extensions_upgrade();<br><br>NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason<br>NOTICE: Packaging extension postgis_raster<br><br>ERROR: extension "postgis_raster" has no installation script nor update path for version "unpackaged"<br>CONTEXT: SQL statement "CREATE EXTENSION postgis_raster SCHEMA public VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.2""<br>PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE<br>SQL state: 22023<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal" style="margin-bottom:12pt">--SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';<u></u><u></u></p></div><div><p class="MsoNormal">"postgis" "3.2.2" "3.2.2" "PostGIS geometry and geography spatial types and functions"<br><br>--only the postgis extension is installed!!!<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--CREATE EXTENSION postgis_raster;<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;letter-spacing:0.1pt">ERROR: PostGIS Raster is already installed in schema 'public' CONTEXT: PL/pgSQL function inline_code_block line 10 at RAISE SQL state: P0001</span><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--SELECT postgis_full_version();<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">"POSTGIS=""3.2.2 3.2.2"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" <u></u><u></u></p></div><div><p class="MsoNormal">GDAL=""GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" <u></u><u></u></p></div><div><p class="MsoNormal">RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal"><br>Thanks for the assistance.<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Marcelo<u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><div><p class="MsoNormal">On Tue, Aug 30, 2022 at 3:56 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt"><div><div><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Marcelo,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Apologies, this file was left out in my packaging. I’ll create an updated package later this week to fix this issue and will also have a 3.3.0 which doesn’t have this issue.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I’ve updated ticket to reflect.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Copy the attached file (which is essentially an empty file) into your </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">C:\Program Files\PostgreSQL\11\share\extension folder</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">And then try your upgrade again.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Sorry for the omission,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Regina</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid 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 [mailto:</span><a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">postgis-users-bounces@lists.osgeo.org</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif">] <b>On Behalf Of </b>Marcelo Marques<br><b>Sent:</b> Tuesday, August 30, 2022 6:08 PM<br><b>To:</b> </span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank"><span style="font-size:11pt;font-family:Calibri,sans-serif">postgis-users@lists.osgeo.org</span></a><span style="font-size:11pt;font-family:Calibri,sans-serif"><br><b>Subject:</b> [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"</span><u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Hello,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">I am trying to get a workaround for the problem below.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:Calibri,sans-serif;color:black">extension "postgis_raster" has no installation script nor update path for version "unpackaged"</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:Calibri,sans-serif;color:black">see more details in this link</span><u></u><u></u></p><p class="MsoNormal"><a href="https://trac.osgeo.org/postgis/ticket/5222#ticket" target="_blank"><span style="font-family:Calibri,sans-serif">https://trac.osgeo.org/postgis/ticket/5222#ticket</span></a><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Have you encountered this issue before? If yes, do you know how to fix it ?</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif">Thanks,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Calibri,sans-serif"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Calibri,sans-serif">| </span><b><span style="font-size:11pt;font-family:Calibri,sans-serif">Marcelo Marques </span></b><span style="font-size:11pt;font-family:Calibri,sans-serif">| Esri PS Products | Principal Product Engineer | </span><u></u><u></u></p></div></div></div></div><p class="MsoNormal">_______________________________________________<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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p></div></blockquote></div></div></div></div></div></div></div><p class="MsoNormal">_______________________________________________<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" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p></div></blockquote></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><br>
</div></blockquote></div>
</blockquote></div>