Opened 6 months ago

Closed 4 months ago

#5582 closed defect (worksforme)

Error upgrading data cluster

Reported by: lucadelu Owned by: strk
Priority: medium Milestone: PostGIS 3.4.2
Component: upgrade Version: 3.4.x
Keywords: Cc:

Description

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");

Change History (6)

comment:1 by robe, 6 months ago

Component: postgisbuild/upgrade/install
Owner: changed from pramsey to strk

comment:2 by robe, 6 months ago

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

comment:3 by strk, 6 months ago

Component: buildupgrade

comment:4 by robe, 5 months ago

Milestone: PostGIS 3.4.1PostGIS 3.4.2

comment:5 by robe, 4 months ago

@lucadelu,

Are you still having issues here?

comment:6 by robe, 4 months ago

Resolution: worksforme
Status: newclosed

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

Note: See TracTickets for help on using tickets.