[postgis-users] procs need upgrade after linux update

[Regina Obe]

You can safely ignore this since your query returns 2.4.9

SELECT postgis_scripts_installed(), postgis_scripts_released();

postgis_scripts_installed | postgis_scripts_released

---------------------------+--------------------------

2.4.9                     | 2.4.9 r0

 

 

The issue is we started our migration from svn to git  and so the revision
number was registering r0 somewhere and we fixed in the 3series (and I think
2.5) but not in older which we planned to End of life (EOL).  I'll check to
make sure we have it fixed in 2.4.10 which will be the last release of 2.4
before we officially mark it as EOL.

 

Thanks,

Regina

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Zwettler Markus (OIZ)
Sent: Tuesday, November 23, 2021 5:47 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] procs need upgrade after linux update

 

Hi,

 

We did a Linux update. Afterwards we saw some ".procs . need upgrade"
messages. We did some "alter extension . update to ." but the message is
still there (see below).

 

Any idea how to solve this?

 

Thanks, Markus

 

 

 

 

 

# select postgis_full_version();

 

  postgis_full_version

 

----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----

----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----

-------------------------

POSTGIS="2.4.9" PGSQL="96" GEOS="3.8.1-CAPI-1.13.3" PROJ="Rel. 7.2.1,
January 1st, 2021" GDAL="GDAL 3.2.3, released 2021/04/27" LIBXML="2.9.1"
LIBJSON="0.11

" LIBPROTOBUF="1.0.2" (core procs from "2.4.4 r16526" need upgrade) TOPOLOGY
(topology procs from "2.4.4 r16526" need upgrade) RASTER (raster procs from
"2.4

.4 r16526" need upgrade)

(1 row)

 

Time: 117.630 ms

# SELECT postgis_scripts_installed(), postgis_scripts_released();

postgis_scripts_installed | postgis_scripts_released

---------------------------+--------------------------

2.4.4 r16526              | 2.4.9 r0

(1 row)

 

Time: 0.340 ms

# ALTER EXTENSION postgis UPDATE TO "2.4.9";

Time: 534.776 ms

# alter extension postgis_topology  UPDATE TO "2.4.9";

Time: 122.938 ms

# SELECT postgis_scripts_installed(), postgis_scripts_released();

postgis_scripts_installed | postgis_scripts_released

---------------------------+--------------------------

2.4.9                     | 2.4.9 r0

(1 row)

 

Time: 0.446 ms

# select postgis_full_version();

 
postgis_

full_version

 

----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----

----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----

----

POSTGIS="2.4.9" PGSQL="96" GEOS="3.8.1-CAPI-1.13.3" PROJ="Rel. 7.2.1,
January 1st, 2021" GDAL="GDAL 3.2.3, released 2021/04/27" LIBXML="2.9.1"
LIBJSON="0.11

" LIBPROTOBUF="1.0.2" (core procs from "2.4.9" need upgrade) TOPOLOGY
(topology procs from "2.4.9" need upgrade) RASTER (raster procs from "2.4.9"
need upgra

de)

(1 row)

 

Time: 2.290 ms

 

 

 

# alter extension postgis  UPDATE TO "2.4.9 r0";

ERROR:  extension "postgis" has no update path from version "2.4.9" to
version "2.4.9 r0"

Time: 0.542 ms

 

# alter extension postgis_topology  UPDATE TO "2.4.9 r0";

ERROR:  extension "postgis_topology" has no update path from version "2.4.9"
to version "2.4.9 r0"

Time: 0.583 ms

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211124/ba6fb4fd/attachment.html>