[postgis-tickets] [PostGIS] #5582: Error upgrading data cluster

[PostGIS]

#5582: Error upgrading data cluster
----------------------+---------------------------
 Reporter:  lucadelu  |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.4.1
Component:  postgis   |    Version:  3.4.x
 Keywords:            |
----------------------+---------------------------
 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");
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5582>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.