Opened 13 months ago

Last modified 11 months ago

#5584 closed defect

PostGIS Upgrade Issue — at Version 2

Reported by: rama Owned by: strk
Priority: critical Milestone: PostGIS Packaging
Component: upgrade/soft Version: 3.3.x
Keywords: windows Cc: rama

Description (last modified by rama)

I am facing an issue with PostGIS Upgrade from 2.5.0 to 3.3.3. Please check and help me out to fix the issue.

Environment Details

Os: Windows Environment (Windows 2016)
Postgresql Version: 11
Postgis Upgrade from 2.5.0 to 3.3.3
Download and installation done from stack builder

Current Version of Database and Postgis

  DATABASE_VERSION                      
------------------------------------------------------------
 PostgreSQL 11.0, compiled by Visual C++ build 1914, 64-bit
(1 row)
POSTGIS_VERSION                                                                                                                      
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 POSTGIS="2.5.0 r16836" [EXTENSION] PGSQL="110" GEOS="3.7.0-CAPI-1.11.0 3.7.0" SFCGAL="1.3.2" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" TOPOLOGY RASTER
(1 row)

Command Execution Details

ALTER EXTENSION postgis UPDATE TO "3.3.3";
ALTER EXTENSION postgis_topology UPDATE TO "3.3.3";
ALTER EXTENSION postgis_sfcgal UPDATE TO "3.3.3";
ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "3.3.3";
ALTER EXTENSION address_standardizer UPDATE TO "3.3.3";
ALTER EXTENSION pgrouting UPDATE TO "3.5.0";
ALTER EXTENSION pointcloud UPDATE TO "1.2.4";
ALTER EXTENSION pointcloud_postgis UPDATE TO "1.2.4";
ALTER EXTENSION ogr_fdw UPDATE TO "1.1";

SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();

ERROR message:

ALTER EXTENSION postgis UPDATE TO "3.3.3";
WARNING:  unpackaging raster
WARNING:  PostGIS Raster functionality has been unpackaged
HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;
ERROR:  could not load library "R:/Database/11/lib/postgis-3.dll": The specified procedure could not be found.


 SELECT postgis_extensions_upgrade();
WARNING:  unpackaging raster
WARNING:  PostGIS Raster functionality has been unpackaged
HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade. After upgrading, if you want to drop raster, run: DROP EXTENSION postgis_raster;
ERROR:  could not load library "R:/Database/11/lib/postgis-3.dll": The specified procedure could not be found.

Change History (2)

comment:1 by rama, 13 months ago

Component: postgisbuild/upgrade/install
Milestone: PostGIS PostgreSQLPostGIS Packaging
Owner: changed from pramsey to strk
Priority: highcritical

comment:2 by rama, 13 months ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.