[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 robe):

 strange - I'm surprised about postgis_sfcgal as that function does exist
 and I thought it had existed in 2.5 version as well.

 Well the easy fix for both pgrouting and postgis_sfcgal is to uninstall
 them and reinstall.

 Generally pgrouting and postgis_sfcgal don't have any data or user
 functions tied to them, so they are safe to drop.  If you do have data and
 functions tied to them, then the below will fail.

 {{{
 DROP EXTENSION postgis_sfcgal;
 CREATE EXTENSION postgis_sfcgal;
 DROP EXTENSION pgrouting;
 CREATE EXTENSION pgrouting;
 }}}


 I'll have to test with a clean postgis 2.5.0 install to rule out if its an
 issue with our upgrade script

 Regarding the postgis_raster, I assume you below twice?  It might have
 failed because of the postgis_sfcgal issue.  Try rerunning again after you
 do the drop/create of postgis_sfcgal in above script.


 {{{
 SELECT postgis_extensions_upgrade();
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5584#comment:13>
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.