[postgis-tickets] [PostGIS] #5222: extension "postgis_raster" has no installation script nor update path for version "unpackaged"
PostGIS
trac at osgeo.org
Wed Aug 31 11:11:38 PDT 2022
#5222: extension "postgis_raster" has no installation script nor update path for
version "unpackaged"
-----------------------+------------------------------------
Reporter: marc3932 | Owner: robe
Type: patch | Status: new
Priority: blocker | Milestone: PostGIS Packaging
Component: raster | Version: 3.2.x
Resolution: | Keywords: postgis_raster windows
-----------------------+------------------------------------
Comment (by marc3932):
-- 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.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5222#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list