[postgis-users] extension "postgis_raster" has no installation script nor update path for version "unpackaged"
Regina Obe
lr at pcorp.us
Wed Aug 31 11:24:34 PDT 2022
Marcelo,
I think it’s your query and below behavior you describe as I understand it seems correct.
And your output is correct:
"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"
Instead of:
SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis';
Should be:
SELECT * FROM pg_available_extensions WHERE name LIKE 'postgis%';
And then the postgis_raster should show along with postgis_topology and postgis_sfcgap and postgis_tiger_geocoder.
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Marcelo Marques
Sent: Wednesday, August 31, 2022 2:03 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"
-- 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 <mailto: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 <mailto:lr at pcorp.us> ]
Sent: Tuesday, August 30, 2022 8:00 PM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org <mailto: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
_______________________________________________
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/20220831/7cee2a10/attachment.htm>
More information about the postgis-users
mailing list