extension "postgis_raster" has no installation script nor update path for version "unpackaged"

[marc3932]

---

Platform:

Windows Server 2019 Standard

PostgreSQL 11.17 x64

PostGIS 3.2.2

---

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)"

*/

---

ALTER EXTENSION postgis UPDATE;

/*

NOTICE: version "3.2.2" of extension "postgis" is already installed

ALTER EXTENSION

Query returned successfully in 512 msec.

*/

---

SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';

1 | "postgis" | "3.2.2" | "3.2.2" | "PostGIS geometry and geography spatial types and functions" |

---

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

*/

---

How can I upgrade to postgis_raster 3.2.2 ???

If I don't have any raster data, then how do I remove pg_raster ???

Thanks,

Marcelo Marques

| Principal Product Engineer | Esri | www.esri.com