I guess my attachment was too big.
Here is a link to it if you need it, https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql 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 https://download.osgeo.org/postgis/windows/pg11/ Hope that helps, Regina From: Regina Obe [mailto:[email protected]] Sent: Tuesday, August 30, 2022 8:00 PM To: 'PostGIS Users Discussion' <[email protected]> Subject: RE: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged" Attached is the one for 3.2.2 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? From: Regina Obe [ <mailto:[email protected]> mailto:[email protected]] Sent: Tuesday, August 30, 2022 7:56 PM To: 'PostGIS Users Discussion' < <mailto:[email protected]> [email protected]> Subject: RE: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged" Oh you are running 3.2.2 and not 3.2.3. I know 3.2.3 has this file postgis_raster--unpackaged--3.2.3.sql which is what you are missing. Can you install 3.2.3? Then once you install the binaries, run again and it should work. From: postgis-users [ <mailto:[email protected]> mailto:[email protected]] On Behalf Of Marcelo Marques Sent: Tuesday, August 30, 2022 7:39 PM To: PostGIS Users Discussion < <mailto:[email protected]> [email protected]> Subject: Re: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged" Hello Regina, I tried but the upgrade still failed, see below. --create an empty file named "postgis--unpackaged.sql" in your share/extension folder of your PostgreSQL install. --This file just has text -- Nothing to do here --C:\Program Files\PostgreSQL\11\share\extension folder --And then try your upgrade again. --SELECT postgis_extensions_upgrade(); NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason NOTICE: Packaging extension postgis_raster ERROR: extension "postgis_raster" has no installation script nor update path for version "unpackaged" CONTEXT: SQL statement "CREATE EXTENSION postgis_raster SCHEMA public VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.2"" PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE SQL state: 22023 --SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis'; "postgis" "3.2.2" "3.2.2" "PostGIS geometry and geography spatial types and functions" --only the postgis extension is installed!!! --CREATE EXTENSION postgis_raster; ERROR: PostGIS Raster is already installed in schema 'public' CONTEXT: PL/pgSQL function inline_code_block line 10 at RAISE SQL state: P0001 --SELECT postgis_full_version(); "POSTGIS=""3.2.2 3.2.2"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" 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)"" RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)" Thanks for the assistance. Marcelo On Tue, Aug 30, 2022 at 3:56 PM Regina Obe <[email protected] <mailto:[email protected]> > wrote: Marcelo, 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. I’ve updated ticket to reflect. Copy the attached file (which is essentially an empty file) into your C:\Program Files\PostgreSQL\11\share\extension folder And then try your upgrade again. Sorry for the omission, Regina From: postgis-users [mailto: <mailto:[email protected]> [email protected]] On Behalf Of Marcelo Marques Sent: Tuesday, August 30, 2022 6:08 PM To: <mailto:[email protected]> [email protected] Subject: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged" Hello, I am trying to get a workaround for the problem below. extension "postgis_raster" has no installation script nor update path for version "unpackaged" see more details in this link <https://trac.osgeo.org/postgis/ticket/5222#ticket> https://trac.osgeo.org/postgis/ticket/5222#ticket Have you encountered this issue before? If yes, do you know how to fix it ? Thanks, | Marcelo Marques | Esri PS Products | Principal Product Engineer | _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
