Opened 2 years ago

Last modified 2 years ago

#5222 closed patch

extension "postgis_raster" has no installation script nor update path for version "unpackaged" — at Version 1

Reported by: marc3932 Owned by: robe
Priority: blocker Milestone: PostGIS Packaging
Component: raster Version: 3.2.x
Keywords: postgis_raster windows Cc:

Description (last modified by marc3932)


Platform:

Windows Server 2019 Standard

PostgreSQL 11.17 x64


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

Change History (1)

comment:1 by marc3932, 2 years ago

Cc: marc3932 removed
Description: modified (diff)
Note: See TracTickets for help on using tickets.