PostGIS Upgrade Issue

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

execute update command for Postgis twice while moving from 2.* to 3.* 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.