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

[Marcelo Marques]

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> 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] *On
> Behalf Of *Marcelo Marques
> *Sent:* Tuesday, August 30, 2022 6:08 PM
> *To:* 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
> 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/b3cc336a/attachment.htm>