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

Marcelo Marques marcelosmbr at gmail.com
Wed Aug 31 11:03:15 PDT 2022


-- Yes, 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

-- NOTE: if postgis_raster already exists then pg_available_extensions
should have showed that, seems another bug to fix !!!

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

--NOTE: pg_available_extensions still does not show postgis_raster but in
pgAdmin when expand the "Extensions" I can see "postgis" and
"postgis_raster".

-- DROP EXTENSION postgis_raster;

DROP EXTENSION

Query returned successfully in 125 msec.

I appreciated your assistance.

Thanks,
Marcelo

On Tue, Aug 30, 2022 at 8:42 PM Regina Obe <lr at pcorp.us> wrote:

> 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 <lr at pcorp.us>]
> *Sent:* Tuesday, August 30, 2022 7:56 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"
>
>
>
> 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
> <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> 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
>
> _______________________________________________
> 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/20220831/6aa50956/attachment.htm>


More information about the postgis-users mailing list