Changes between Initial Version and Version 1 of Ticket #5301, comment 1


Ignore:
Timestamp:
Dec 9, 2022, 9:53:51 AM (19 months ago)
Author:
robe

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #5301, comment 1

    initial v1  
    11I'm suspecting it's the spatial_ref_sys change since upgrading to PostGIS 3.2.3 worked fine.
     2I should add this server has existed since the 1.0 days so the spatial_ref_sys table is probably very out of date.
    23
    3 The server is running PostgreSQL 11.7.
     4The server was running PostgreSQL 11.7.  We upgraded it to latest PostgreSQL:
    45
     6It now shows:
     7
     8
     9{{{
     10POSTGIS="3.3.2 3.3.2" [EXTENSION] PGSQL="110" GEOS="3.11.1-CAPI-1.17.1" PROJ="7.2.1" GDAL="GDAL 3.4.3, released 2022/04/22" LIBXML="2.9.9" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" (core procs from "3.2.3 3.2.3" need upgrade) TOPOLOGY (topology procs from "3.2.3 3.2.3" need upgrade) RASTER (raster procs from "3.2.3 3.2.3" need upgrade) (deprecated functions exist, upgrade is not complete) PostgreSQL 11.18, compiled by Visual C++ build 1914, 64-bit
     11}}}
     12
     13Tried to upgrade again and got same issue.  So I guess there is a downside to how we are upgrading spatial_ref_sys.  Not sure if there is anything we can do about this.
     14
     15