[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:  blocker                |  Milestone:  PostGIS 2.5.0
 Component:  build/upgrade/install  |    Version:  trunk
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by robe):

 Okay I put these back and that got rid of the pgis_abs error, but I'm
 still getting troubling crashes in raster and in different location from
 what I got earlier.


 {{{
 pg_restore: creating COMMENT "public.FUNCTION
 "addgeometrycolumn"("catalog_name" character varying, "schema_name"
 character varying, "table_name" character varying, "column_name" character
 varying, "new_srid_in" integer, "new_type" character varying, "new_dim"
 integer, "use_typmod" boolean)"
 pg_restore: creating FUNCTION "public.addoverviewconstraints("name",
 "name", "name", "name", integer)"
 pg_restore: creating COMMENT "public.FUNCTION
 "addoverviewconstraints"("ovtable" "name", "ovcolumn" "name", "reftable"
 "name", "refcolumn" "name", "ovfactor" integer)"
 pg_restore: creating FUNCTION "public.addoverviewconstraints("name",
 "name", "name", "name", "name", "name", integer)"
 pg_restore: creating COMMENT "public.FUNCTION
 "addoverviewconstraints"("ovschema" "name", "ovtable" "name", "ovcolumn"
 "name", "refschema" "name", "reftable" "name", "refcolumn" "name",
 "ovfactor" integer)"
 pg_restore: creating FUNCTION "public.addrasterconstraints("name", "name",
 "text"[])"
 pg_restore: creating COMMENT "public.FUNCTION
 "addrasterconstraints"("rasttable" "name", "rastcolumn" "name", VARIADIC
 "constraints" "text"[])"
 pg_restore: creating FUNCTION "public.addrasterconstraints("name", "name",
 "name", "text"[])"
 pg_restore: creating COMMENT "public.FUNCTION
 "addrasterconstraints"("rastschema" "name", "rasttable" "name",
 "rastcolumn" "name", VARIADIC "constraints" "text"[])"
 pg_restore: creating FUNCTION "public.addrasterconstraints("name", "name",
 boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean,
 boolean, boolean, boolean, boolean)"
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 1172; 1255 16806 FUNCTION
 addrasterconstraints("name", "name", boolean, boolean, boolean, boolean,
 boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean)
 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: ALTER FUNCTION
 "public"."addrasterconstraints"("rasttable" "name", "rastcolumn" "name",
 "srid" boolean, "scale_x" boolean, "scale_y" boolean, "blocksize_x"
 boolean, "blocksize_y" boolean, "same_alignment" boolean,
 "regular_blocking" boolean, "num_bands" boolean, "pixel_types" boolean,
 "nodata_values" boolean, "out_db" boolean, "extent" boolean) OWNER TO
 postgres;


 command:
 "C:\ming64gcc48\projects\postgresql\rel\pg11w64gcc48\bin/pg_restore"
 --port 5448 --username postgres --clean --create --exit-on-error --verbose
 --dbname template1 "pg_upgrade_dump_12938.custom" >>
 "pg_upgrade_dump_12938.log" 2>&1
 }}}

 So I'll leave this open until I figure out what's up here.

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