Error upgrading data cluster

[lucadelu]

I'm trying to upgrade my databases using pg_upgrade from version PostgreSQL 14 to 15, PostGIS version is 3.4.0 for both server. My pg_upgrade command is

/usr/lib/postgresql/15/bin/pg_upgrade --old-datadir=/var/lib/postgresql/14/main --new-datadir=/var/lib/postgresql/15/main --old-bindir=/usr/lib/postgresql/14/bin --new-bindir=/usr/lib/postgresql/15/bin --old-options '-c config_file=/etc/postgresql/14/main/postgresql.conf' --new-options '-c config_file=/etc/postgresql/15/main/postgresql.conf'

the error I get is

pg_restore: creating FUNCTION "public.pgis_geometry_coverageunion_finalfn("internal")"

pg_restore: while PROCESSING TOC:

pg_restore: from TOC entry 587; 1255 1211479 FUNCTION pgis_geometry_coverageunion_finalfn("internal") lucadelu

pg_restore: error: could not execute query: ERROR:  could not find function "pgis_geometry_coverageunion_finalfn" in file "/usr/lib/postgresql/15/lib/postgis-3.so"

Command was: CREATE FUNCTION "public"."pgis_geometry_coverageunion_finalfn"("internal") RETURNS "public"."geometry"
    LANGUAGE "c" COST 250 PARALLEL SAFE
    AS '$libdir/postgis-3', 'pgis_geometry_coverageunion_finalfn';
 
-- For binary upgrade, handle extension membership the hard way
ALTER EXTENSION "postgis" ADD FUNCTION "public"."pgis_geometry_coverageunion_finalfn"("internal");

[robe]

Can you give us the output below for your existing postgis install.

SELECT postgis_full_version(), version()

I was thinking maybe you had forgotten to run

SELECT postgis_extensions_upgrade();

But that function you have in the postgis-3.so complaint is a function introduced in 3.4 so should be there in both installs unless somehow your PG15 is got an .so for an older version like possibly 3.3.

What distro are you using for PostGIS? Could be a bug in the distro giving you an older version of PostGIS in PG15

[robe]

@lucadelu,

Are you still having issues here?

[robe]

Closing this out since I can't replicate and no response.