[postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"

Tue Aug 30 16:56:12 PDT 2022

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:postgis-users-bounces at lists.osgeo.org] On Behalf Of Marcelo Marques
Sent: Tuesday, August 30, 2022 7:39 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
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 <lr at pcorp.us <mailto:lr at pcorp.us> > 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:postgis-users-bounces at lists.osgeo.org <mailto:postgis-users-bounces at lists.osgeo.org> ] On Behalf Of Marcelo Marques
Sent: Tuesday, August 30, 2022 6:08 PM
To: postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
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
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220830/1951f13b/attachment.htm>