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]> 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:[email protected]] *On > Behalf Of *Marcelo Marques > *Sent:* Tuesday, August 30, 2022 6:08 PM > *To:* [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 > > > > 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] > https://lists.osgeo.org/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
