[postgis-tickets] [PostGIS] #4712: postgis installer for windows has old proj

[PostGIS]

#4712: postgis installer for windows has old proj
----------------------+-------------------------------
  Reporter:  zellner  |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS Packaging
 Component:  postgis  |    Version:  3.0.x
Resolution:           |   Keywords:  windows
----------------------+-------------------------------

Comment (by zellner):

 Step by step I tried 3 zip files to update my PostgreSQL directory using
 all subfolders and even the version.txt file downloaded from:
 https://winnie.postgis.net/download/windows/pg12/buildbot/
 These are the files:
 - postgis-pg12-binaries-3.1.0devw64gcc81.zip
 - pgrouting-pg12-binaries-developw64gcc81.zip
 - pg12pgh3_w64.zip

 I always stopped the PostgreSQL service and started it again. At last I
 restarted the computer.
 There are still shown the old versions:
 SELECT version() UNION ALL
 SELECT PostGIS_full_version();

 PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1
 20190507 (Red Hat 8.3.1-4), 64-bit
 POSTGIS="3.0.1 ec2a9aa" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 "
 PROJ="6.3.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
 WAGYU="0.4.3 (Internal)"

 And the results of ST_Transform(...) are still the wrong ones comparing
 "my" PostgreSQL database running on Windows with a Linunx database:
 -- (Windows wrong) ---------------------------------
 NAV4  POINT(4443865 5506116)
 WGS84 POINT(11.22192780146776 49.690197542586986)
 NAV4  POINT(4443864.999999998 5506115.999999998)
 -- (Linux right) ---------------------------------
 NAV4  POINT(4443865 5506116)
 WGS84 POINT(11.220567440054587 49.68909694949477)
 NAV4  POINT(4443865.000344981 5506116.000483332)

 The Linux versions are:
 PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1
 20190507 (Red Hat 8.3.1-4), 64-bit
 POSTGIS="3.0.1 ec2a9aa" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 "
 PROJ="6.3.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
 WAGYU="0.4.3 (Internal)"

 So the problem is not solved. Did I do something wrong when substituting
 the sources as described above? Can you test it? You find the test block
 in the very first comment in the ticket.

 Axel

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