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

Tue Aug 30 20:41:28 PDT 2022

I guess my attachment was too big.

Here is a link to it if you need it,  https://winnie.postgis.net/download/windows/pg11/buildbot/extras/postgis--unpackaged--3.2.2.sql

but if you are running a patched PostgreSQL 11, you’ll really need to be using the PostGIS 3.2.3 install which you can get from application stackbuilder or https://download.osgeo.org/postgis/windows/pg11/

Hope that helps,

Regina

From: Regina Obe [mailto:lr at pcorp.us] 
Sent: Tuesday, August 30, 2022 8:00 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"

Attached is the one for 3.2.2

But that is in my artifacts so should have already been installed by your setup.  Do you have the attached file in your share/extension folder?

From: Regina Obe [ <mailto:lr at pcorp.us> mailto:lr at pcorp.us] 
Sent: Tuesday, August 30, 2022 7:56 PM
To: 'PostGIS Users Discussion' < <mailto:postgis-users at lists.osgeo.org> postgis-users at lists.osgeo.org>
Subject: RE: [postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"

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> 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 < <mailto:postgis-users at lists.osgeo.org> 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: <mailto:postgis-users-bounces at lists.osgeo.org> postgis-users-bounces at lists.osgeo.org] On Behalf Of Marcelo Marques
Sent: Tuesday, August 30, 2022 6:08 PM
To:  <mailto:postgis-users at lists.osgeo.org> 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> 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/85a174fb/attachment.htm>