[postgis-tickets] [PostGIS] #5141: Unable to upgrade PostGIS from 2.x to 3.2.1 on PostgreSQL 9.6.x

[PostGIS]

#5141: Unable to upgrade PostGIS from 2.x to 3.2.1 on PostgreSQL 9.6.x
------------------------------------+---------------------------
  Reporter:  milosh                 |      Owner:  robe
      Type:  defect                 |     Status:  new
  Priority:  high                   |  Milestone:  PostGIS 3.2.2
 Component:  build/upgrade/install  |    Version:  3.2.x
Resolution:                         |   Keywords:  windows
------------------------------------+---------------------------

Comment (by milosh):

 I have solved the issue somehow.

 I remember that when updating PostgreSQL 9.6 minor versions I needed in
 the past to manually copy libeay32.dll and ssleay32.dll from
 bin/postgisgui to PostgreSQL bin directory - otherwise I would get errors
 like "rtpostgis-2.3.dll: %1 is not a valid Win32 application".

 I tried to install http://download.osgeo.org/postgis/windows/pg96/archive
 /postgis-bundle-pg96x64-setup-3.0.1-1.exe just to test if there is not
 some issue with DLLs and figured out that zlib1.dll was not found in PATH.

 So I copied zlib1.dll again from bin/postgisgui into PostgreSQL bin
 directory and then
 {{{
 CREATE EXTENSION postgis_raster from unpackaged;
 }}}
 just worked.

 So I repeated those steps with
 http://download.osgeo.org/postgis/windows/pg96/postgis-bundle-
 pg96x64-setup-3.2.1-1.exe, i.e. again after install manually copied
 libeay32.dll, ssleay32.dll and zlib1.dll from bin/postgisgui into bin/ and
 voila:
 {{{
 CREATE EXTENSION postgis_raster from unpackaged;
 }}}
 also worked.

 So the update path from PostGIS 2.3.7 to 3.2.1 in my case is:

 1/ Install http://download.osgeo.org/postgis/windows/pg96/postgis-bundle-
 pg96x64-setup-3.2.1-1.exe

 2/ Manually copy libeay32.dll, ssleay32.dll and zlib1.dll from
 bin/postgisgui into bin/

 3/ Run:
 {{{
 ALTER EXTENSION postgis UPDATE;
 CREATE EXTENSION postgis_raster from unpackaged;
 SELECT postgis_extensions_upgrade();
 SELECT postgis_extensions_upgrade();
 }}}

 Than I get:
 {{{
 Upgrade completed, run SELECT postgis_full_version(); for details
 }}}

 And SELECT postgis_full_version() gives:
 {{{
 POSTGIS="3.2.1 3.2.1" [EXTENSION] PGSQL="96" GEOS="3.10.2-CAPI-1.16.0"
 PROJ="7.2.1" GDAL="GDAL 3.4.2, released 2022/03/08 GDAL_DATA not found"
 LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
 RASTER
 }}}

 I think we can close this ticket as WONTFIX.

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