[postgis-users] procs need upgrade after linux update

Zwettler Markus (OIZ) Markus.Zwettler at zuerich.ch
Tue Nov 23 02:46:39 PST 2021


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/20211123/57d4135a/attachment.html>


More information about the postgis-users mailing list