This means that your current "default" PostGIS version is 2.4.9,
so "postgis_extensions_upgrade()" tries to upgrade to that version,
but it's actually a DOWNGRADE instead.
very strange:
# apt policy postgis
postgis:
Installed: 3.3.1+dfsg-1.pgdg110+1
Candidate: 3.3.1+dfsg-1.pgdg110+1
I'm using a debian stable from some years, I have always used "apt" to
upgrade my packages so I never worried about version compatibility etc...
Note the "need upgrade" message.
I noticed it, and I noticed something wrong, but I though was just
raster lib (the only 2.4.9 version of the whole stuff)
My suggestion is to (re)install PostGIS 3.3.1 to ensure it's listed
as the default version and run `postgis_extensions_upgrade()`.
Ok, I like it, but could there be some problem during re-installation? I
have 10 db running and I would like to avoid disasters or users panic !!
What is the correct procedure?
thanx
Il 30/09/22 17:44, Sandro Santilli ha scritto:
On Fri, Sep 30, 2022 at 09:25:38AM +0200, Giuseppe Naponiello wrote:
POSTGIS="3.3.1 3786b21" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2"
PROJ="7.2.1" GDAL="GDAL 3.2.2, released 2021/03/05" LIBXML="2.9.10"
LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)" (core procs from
"3.1.4 ded6c34" need upgrade) RASTER (raster lib from "2.4.9 r0" need
upgrade) [UNPACKAGED!] (raster procs from "2.4.9" need upgrade)
Note the "need upgrade" message.
ERROR: A stored procedure tried to use deprecated C function
'pgis_geometry_union_finalfn'
DETAIL: Library function 'pgis_geometry_union_finalfn' was deprecated in
PostGIS 3.3.0
HINT: Consider running: SELECT postgis_extensions_upgrade()
Great message!
and if I run this select I have:
ERROR: extension "postgis" has no update path from version "3.1.4" to
version "2.4.9"
This means that your current "default" PostGIS version is 2.4.9,
so "postgis_extensions_upgrade()" tries to upgrade to that version,
but it's actually a DOWNGRADE instead.
Also, it looks like your PostgreSQL thinks the PostGIS extension
version you have installed is 3.3.1 but you never really upgraded
the scripts to that version (they are stuck at 3.1.4).
Any tips?
My suggestion is to (re)install PostGIS 3.3.1 to ensure it's listed
as the default version and run `postgis_extensions_upgrade()`.
Or you can do this manually by editing postgis.control (but
re-installing is less error prone).
Note there's a feature request issue for postgis_extensions_upgrade()
to accept a target version, which would have helped in your case:
https://trac.osgeo.org/postgis/ticket/5052
--strk;
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
