[postgis-tickets] [PostGIS] #4097: binary upgrade fail going from 10 (2.4) to 11 (head) (2.5)

[PostGIS]

#4097: binary upgrade fail going from 10 (2.4) to 11 (head) (2.5)
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  robe
     Type:  defect                 |     Status:  assigned
 Priority:  medium                 |  Milestone:  PostGIS 2.5.0
Component:  build/upgrade/install  |    Version:  trunk
 Keywords:                         |
-----------------------------------+---------------------------
 This I did by copying the pg 11 2.5 binaries (renaming to 2.4)
 and doing a pg_upgrade from pg 10.1 to 11beta1 (aroundish a little higher
 than beta1).

 It failed in an unexpected location so could be my setup at fault and
 nothing in our code.


 {{{
 pg_restore: connecting to database for restore
 pg_restore: dropping DATABASE PROPERTIES postgres
 pg_restore: dropping DATABASE postgres
 pg_restore: creating DATABASE "postgres"
 pg_restore: connecting to new database "postgres"
 pg_restore: connecting to database "postgres" as user "postgres"
 pg_restore: creating COMMENT "DATABASE "postgres""
 pg_restore: creating DATABASE PROPERTIES "postgres"
 pg_restore: connecting to new database "postgres"
 pg_restore: connecting to database "postgres" as user "postgres"
 pg_restore: creating pg_largeobject "pg_largeobject"
 pg_restore: creating pg_largeobject_metadata "pg_largeobject_metadata"
 pg_restore: creating EXTENSION "postgis"
 pg_restore: creating COMMENT "EXTENSION "postgis""
 pg_restore: creating TYPE "public.addbandarg"
 pg_restore: creating COMMENT "public.TYPE "addbandarg""
 pg_restore: creating TYPE "public.agg_count"
 pg_restore: creating SHELL TYPE "public.raster"
 pg_restore: creating FUNCTION "public.raster_in("cstring")"
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 545; 1255 33854 FUNCTION
 raster_in("cstring") postgres
 pg_restore: [archiver (db)] could not execute query: FATAL:  terminating
 connection due to administrator command
 server closed the connection unexpectedly
         This probably means the server terminated abnormally
         before or while processing the request.
     Command was: CREATE FUNCTION "public"."raster_in"("cstring") RETURNS
 "public"."raster"
     LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE
     AS '$libdir/rtpostgis-2.5', 'RASTER_in';

 -- For binary upgrade, handle extension membership the hard way
 ALTER EXTENSION "postgis" ADD FUNCTION "public"."raster_in"("cstring");
 }}}


 I'm going to try next doing the regular binary upgrade, by that I mean
 upgrading my pg 10 to PostGIS 2.5 and then migrating to PostgreSQL 11
 PostGIS 2.5

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4097>
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.