[PostGIS] #5584: PostGIS Upgrade Issue

[PostGIS]

#5584: PostGIS Upgrade Issue
------------------------------------+-------------------------------
  Reporter:  rama                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  critical               |  Milestone:  PostGIS Packaging
 Component:  build/upgrade/install  |    Version:  3.3.x
Resolution:                         |   Keywords:  windows
------------------------------------+-------------------------------
Comment (by rama):

 As recommended I have updated the PostgreSQL version to 11.21

 The good news is that Postgis is upgraded to 3.3.3!! But Postgis_raster
 doesn't exist in the extension list

  But facing issues with raster, sfcgal, and pgrouting Could you please
 suggest what could we do for the same

 {{{
 ALTER EXTENSION postgis UPDATE TO "3.3.3";
 WARNING:  unpackaging raster
 WARNING:  PostGIS Raster functionality has been unpackaged
 HINT:  type `SELECT postgis_extensions_upgrade();` to finish the upgrade.
 After upgrading, if you want to drop raster, run: DROP EXTENSION
 postgis_raster;
 ALTER EXTENSION

 SELECT postgis_extensions_upgrade();
 NOTICE:  Updating extension postgis 3.3.3
 NOTICE:  Updating extension postgis_sfcgal 2.5.0
 ERROR:  aggregate st_3dunion(geometry) does not exist
 CONTEXT:  SQL statement "UPDATE pg_catalog.pg_extension SET extversion =
 'ANY' WHERE extname = 'postgis_sfcgal';ALTER EXTENSION postgis_sfcgal
 UPDATE TO "3.3.3""
 PL/pgSQL function postgis_extensions_upgrade() line 104 at EXECUTE

 SELECT postgis_extensions_upgrade();
 NOTICE:  Updating extension postgis 3.3.3
 NOTICE:  Updating extension postgis_sfcgal 2.5.0
 ERROR:  aggregate st_3dunion(geometry) does not exist
 CONTEXT:  SQL statement "UPDATE pg_catalog.pg_extension SET extversion =
 'ANY' WHERE extname = 'postgis_sfcgal';ALTER EXTENSION postgis_sfcgal
 UPDATE TO "3.3.3""
 PL/pgSQL function postgis_extensions_upgrade() line 104 at EXECUTE
 }}}


 When I try to upgrade pgrouting and  postgis_sfcgal extension i get an
 Error

 {{{
 ##postgis_sfcgal
 ALTER EXTENSION postgis_sfcgal UPDATE TO "3.3.3";
 ERROR:  aggregate st_3dunion(geometry) does not exist

 ##pgrouting
 ALTER EXTENSION pgrouting UPDATE TO "3.5.0";
 ERROR:  function pgr_dijkstra(text, bigint, anyarray, boolean) does not
 exist
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:12>
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.