Opened 10 months ago
Closed 10 months ago
Last modified 10 months ago
#5209 closed defect (fixed)
Upgrade issue with topology
|Reported by:||robe||Owned by:||strk|
When building packages today for the new postgres releases I ran into the below error for the PostGIS package when running tests: ALTER EXTENSION ERROR: function layertrigger() is not a member of extension "postgis_topology" DETAIL: An extension is not allowed to replace an object that it does not own. It seems that it's related to the CVE which was fixed in the new postgres releases today.
Change History (11)
comment:1 by , 10 months ago
comment:2 by , 10 months ago
This issue is present with all PostgreSQL version from 10 to 14, see https://www.postgresql.org/support/security/CVE-2022-2625/
In PostGIS this should be fixed in master branch (3.3.0rc1) with [cb65cd89737d14c386ef004fe270de953338a7e9/git]
I guess we want to backport that commit in all stable branches, not just 3.2 ?
comment:3 by , 10 months ago
according to https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS latest PostgreSQL supported by PostGIS 2.5 is 12, earliest supported by PostGIS 3.2 is 9.6
I'm going to setup a PostGIS 12 to test this out locally in all supported version (back to 2.5 branch) and then work on a fix when needed.
comment:4 by , 10 months ago
To correct what's written in comment:1 the reported problem happens when upgrading from _unpackaged_ postgis. It's reported to happen in versions 2.5.5 and 3.2.1 but I know it will also happen in versions 3.0.6 and 3.1.6.
It was reported that with 3.2.2 the problem can be reproduced running:
make installcheck-upgrade from the build dir.
comment:5 by , 10 months ago
The problem can be reproduced in all stable branches with:
regress/run_test.pl -v --extension --upgrade --upgrade-path unpackaged--2.5.8dev regress/regress
The target version has to be replaced with the currently-built and installed postgis version
comment:6 by , 10 months ago
CI bots are catching the problem already: https://gitlab.com/postgis/postgis/-/jobs/2848275869
comment:7 by , 10 months ago
comment:8 by , 10 months ago
comment:9 by , 10 months ago
comment:10 by , 10 months ago
|Status:||new → closed|
comment:11 by , 10 months ago
|Milestone:||PostGIS 3.2.3 → PostGIS 2.5.8|
Happens when upgrading from 2.5.5 o 3.2.1