[postgis-tickets] [PostGIS] #5221: function bytea(raster) is not a member of extension "postgis_raster" error when upgrading postgis 2.5.5 to 3.2.2

PostGIS trac at osgeo.org
Thu Aug 18 08:31:07 PDT 2022


#5221: function bytea(raster) is not a member of extension "postgis_raster" error
when upgrading postgis 2.5.5 to 3.2.2
-------------------------+---------------------------
  Reporter:  ryanfrench  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 3.2.3
 Component:  postgis     |    Version:  3.2.x
Resolution:              |   Keywords:
-------------------------+---------------------------
Description changed by ryanfrench:

Old description:

> When attempting to upgrade our Postgis extension from 2.5.5 to 3.2.2 the
> following error is shown. This has worked previously during tests when
> moving to both 3.2.1 and 3.2.2, but has started failing in the last 2
> weeks. The server is running on Ubuntu using the pgdg repository.
>
> SELECT public.postgis_extensions_upgrade();
> 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;
> NOTICE:  ALTER EXTENSION postgis UPDATE TO "3.2.2";
> d6l61m092figvj=# SELECT public.postgis_extensions_upgrade();
> NOTICE:  Extension postgis_sfcgal is not available or not packagable for
> some reason
> NOTICE:  Packaging extension postgis_raster
> ERROR:  function bytea(raster) is not a member of extension
> "postgis_raster"
> DETAIL:  An extension is not allowed to replace an object that it does
> not own.
> CONTEXT:  SQL statement "CREATE EXTENSION postgis_raster SCHEMA public
> VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.2""
> PL/pgSQL function public.postgis_extensions_upgrade() line 71 at EXECUTE

New description:

 When attempting to upgrade our Postgis extension from 2.5.5 to 3.2.2 the
 following error is shown. This has worked previously during tests when
 moving to both 3.2.1 and 3.2.2, but has started failing in the last 2
 weeks. The server is running on Ubuntu using the pgdg repository.

 SELECT public.postgis_extensions_upgrade();
 {{{
 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;
 NOTICE:  ALTER EXTENSION postgis UPDATE TO "3.2.2";
 d6l61m092figvj=# SELECT public.postgis_extensions_upgrade();
 NOTICE:  Extension postgis_sfcgal is not available or not packagable for
 some reason
 NOTICE:  Packaging extension postgis_raster
 ERROR:  function bytea(raster) is not a member of extension
 "postgis_raster"
 DETAIL:  An extension is not allowed to replace an object that it does not
 own.
 CONTEXT:  SQL statement "CREATE EXTENSION postgis_raster SCHEMA public
 VERSION unpackaged;ALTER EXTENSION postgis_raster UPDATE TO "3.2.2""
 PL/pgSQL function public.postgis_extensions_upgrade() line 71 at EXECUTE
 }}}

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


More information about the postgis-tickets mailing list