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

---

CREATE EXTENSION postgis_raster SCHEMA public VERSION unpackaged;

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

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

[robe]

Apologies, this is a packaging bug on my part.

To fix create an empty file in your share/extension folder of your PostgreSQL install.

This file just has text

-- Nothing to do here

[robe]

related mailing list item: ​https://lists.osgeo.org/pipermail/postgis-users/2022-August/045624.html

[marc3932]

I tried but the upgrade still fails, see details 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 RAISESQL 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)"

[marc3932]

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

C:\Program Files\PostgreSQL\11\share\extension>dir postgis—unpackaged*.*

Directory of C:\Program Files\PostgreSQL\11\share\extension

03/11/2019 12:12 PM 1,475,393 postgis—unpackaged—2.5.2.sql 07/30/2022 12:49 AM 1,068,869 postgis—unpackaged—3.2.2.sql 08/30/2022 04:14 PM 21 postgis—unpackaged.sql

— I compared the file C:\Program Files\PostgreSQL\11\share\extension\postgis—unpackaged—3.2.2.sql on my server with the one from — ​https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql —and they are identical, and still fails to upgrade.

— 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

— I followed you suggestion and installed Postgis 3.2.3 for PostgreSQL 11 — I checked and PostGIS 3.2.3 has the empty file "C:\Program Files\PostgreSQL\11\share\extension\postgis—unpackaged.sql" — This file just has text "— Nothing to do here"

C:\Program Files\PostgreSQL\11\share\extension>dir postgis—unpa*.*

Directory of C:\Program Files\PostgreSQL\11\share\extension

03/11/2019 12:12 PM 1,475,393 postgis—unpackaged—2.5.2.sql 08/19/2022 04:24 PM 1,465,258 postgis—unpackaged—3.2.3.sql 08/30/2022 04:14 PM 21 postgis—unpackaged.sql

— I was able to upgrade the postgis extension — and upgrade the raster extension and then — remove the raster extension and — if I want I can reinstall postgis_raster extension

— SELECT postgis_full_version();

"POSTGIS=""3.2.3 3.2.3"" [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)"" (core procs from ""3.2.2 3.2.2"" need upgrade) ⇐= !!! 3.2.2 NEED UPGRADE !!! RASTER (raster lib from ""2.5.2 r17328"" need upgrade) [UNPACKAGED!] (raster procs from ""2.5.2 r17328"" need upgrade)"

— ALTER EXTENSION postgis UPDATE;

Query returned successfully in 599 msec.

— SELECT postgis_full_version();

"POSTGIS=""3.2.3 3.2.3"" [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.3" of extension "postgis" is already installed ALTER EXTENSION

Query returned successfully in 160 msec.

— SELECT postgis_extensions_upgrade();

"Upgrade completed, run SELECT postgis_full_version(); for details"

NOTICE: Updating extension postgis from 3.2.2 to 3.2.3

NOTICE: Extension postgis_sfcgal is not available or not packagable for some reason

NOTICE: Packaging extension postgis_raster

WARNING: 'postgis.gdal_datapath' is already set and cannot be changed until you reconnect

WARNING: 'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect

WARNING: 'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect

NOTICE: Extension postgis_topology is not available or not packagable for some reason

NOTICE: Extension postgis_tiger_geocoder is not available or not packagable for some reason

Successfully run. Total query runtime: 1 secs 884 msec. 1 rows affected.

— SELECT postgis_full_version();

"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" GDAL=""GDAL 3.4.3, released 2022/04/22 GDAL_DATA not found"" LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"" RASTER"

— SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';

"postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions"

— CREATE EXTENSION postgis_raster;

ERROR: extension "postgis_raster" already exists SQL state: 42710

— DROP EXTENSION postgis_raster;

DROP EXTENSION

Query returned successfully in 125 msec.

— SELECT postgis_full_version();

"POSTGIS=""3.2.3 3.2.3"" [EXTENSION] PGSQL=""110"" GEOS=""3.10.3-CAPI-1.16.1"" PROJ=""7.2.1"" LIBXML=""2.9.9"" LIBJSON=""0.12"" LIBPROTOBUF=""1.2.1"" WAGYU=""0.5.0 (Internal)"""

—NOTE: RASTER EXTENSION REMOVED !!!

— Try to install postgis_raster extension

— CREATE EXTENSION postgis_raster;

CREATE EXTENSION

Query returned successfully in 252 msec.

— SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';

"postgis" "3.2.3" "3.2.3" "PostGIS geometry and geography spatial types and functions"

— DROP EXTENSION postgis_raster;

DROP EXTENSION

Query returned successfully in 125 msec.

[robe]

Closing this out as it seems the 3.2.3 packaging was fine. Just the 3.2.2 had issues.