[postgis-tickets] [PostGIS] #5141: Unable to upgrade PostGIS from 2.x to 3.2.1 on PostgreSQL 9.6.x

[PostGIS]

#5141: Unable to upgrade PostGIS from 2.x to 3.2.1 on PostgreSQL 9.6.x
---------------------+---------------------------
 Reporter:  milosh   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  high     |  Milestone:  PostGIS 3.2.2
Component:  postgis  |    Version:  3.2.x
 Keywords:           |
---------------------+---------------------------
 Trying to upgrade PostGIS 2.3.7 or 2.5.2 enabled PostgreSQL 9.6 database
 (tried both PostGIS versions) fails when running:

 {{{
 SELECT postgis_extensions_upgrade();
 }}}

 with:

 {{{
 NOTICE:  Extension postgis_sfcgal is not available or not packagable for
 some reason
 NOTICE:  Packaging extension postgis_raster

 ERROR:  could not stat file "C:/Program
 Files/PostgreSQL/9.6/share/extension/postgis_raster--unpackaged.sql": No
 such file or directory
 CONTEXT:  SQL statement "CREATE EXTENSION postgis_raster SCHEMA public
 VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.1""
 PL/pgSQL funkce postgis_extensions_upgrade() řádek 71 na EXECUTE
 SQL state: 58P01
 }}}

 postgis full version gives (for PostGIS 2.5.2 database):

 {{{
 "POSTGIS="3.2.1 3.2.1" [EXTENSION] PGSQL="96" GEOS="3.10.2-CAPI-1.16.0"
 PROJ="7.2.1" GDAL="GDAL 2.2.4, released 2018/03/19" LIBXML="2.9.9"
 LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
 (topology procs from "2.5.2 r17328" need upgrade) RASTER (raster lib from
 "2.5.2 r17328" need upgrade) [UNPACKAGED!] (raster procs from "2.5.2
 r17328" need upgrade)"
 }}}

 and for PostGIS 2.3.7 database:

 "POSTGIS="3.2.1 3.2.1" [EXTENSION] PGSQL="96" GEOS="3.10.2-CAPI-1.16.0"
 PROJ="7.2.1" GDAL="GDAL 2.2.4, released 2018/03/19" LIBXML="2.9.9"
 LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)" RASTER (raster
 lib from "2.3.7 r16523" need upgrade) [UNPACKAGED!] (raster procs from
 "2.3.7 r16523" need upgrade)"
 }}}

 Raster functions are not used. Any idea? Hard reload somehow?

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