[postgis-tickets] [PostGIS] #5584: PostGIS Upgrade Issue

[PostGIS]

#5584: PostGIS Upgrade Issue
------------------------------------+-------------------------------
  Reporter:  rama                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  critical               |  Milestone:  PostGIS Packaging
 Component:  build/upgrade/install  |    Version:  3.3.x
Resolution:                         |   Keywords:
------------------------------------+-------------------------------
Description changed by rama:

Old description:

> 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.

New description:

 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.
 }}}

--
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:2>
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.