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 )
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 , 13 months ago
Component: | postgis → build/upgrade/install |
---|---|
Milestone: | PostGIS PostgreSQL → PostGIS Packaging |
Owner: | changed from | to
Priority: | high → critical |
comment:2 by , 13 months ago
Description: | modified (diff) |
---|
Note:
See TracTickets
for help on using tickets.