[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:  closed
  Priority:  high                   |  Milestone:  PostGIS 3.2.2
 Component:  build/upgrade/install  |    Version:  3.2.x
Resolution:  invalid                |   Keywords:  windows
------------------------------------+---------------------------
Changes (by milosh):

 * status:  new => closed
 * resolution:   => invalid


Comment:

 {{{
 SELECT version()
 }}}
 returns:

 {{{
 "PostgreSQL 9.6.20, compiled by Visual C++ build 1800, 64-bit"
 }}}

 It is possible that ssleay32 and libeay32 DLLs copy was not needed. I have
 not tried that. It had to do that every time when installing update to
 PostgreSQL minor version to prevent
 {{{
 "rtpostgis-2.3.dll: %1 is not a valid Win32 application".
 }}}
 error.

 On the other hand without copying zlib1.dll, I got the error:
 {{{
 "C:/Program Files/PostgreSQL/9.6/lib/postgis_raster-3.dll":
 The specified procedure could not be found.
 }}}
 when running
 {{{
 CREATE EXTENSION postgis_raster from unpackaged
 }}}
 under PostGIS 3.2.1 and
 {{{
 "C:/Program Files/PostgreSQL/9.6/lib/postgis_raster-3.dll":
 The specified module could not be found.
 }}}
 when running the same command under PostGIS 3.0.1-1. While looking into
 Sysinternals Procmon I observed that zlib1.dll was not loaded successfuly
 from PostgreSQL bin directory during execution of the above command, so I
 tried to overwrite it with zlib1.dll from postgisgui directory and that
 worked.

 Not sure why, it's hard to debug such errors.

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