Opened 2 years ago

Last modified 2 years ago

#5221 closed defect

function bytea(raster) is not a member of extension "postgis_raster" error when upgrading postgis 2.5.5 to 3.2.2 — at Version 1

Reported by: ryanfrench Owned by: pramsey
Priority: medium Milestone: PostGIS 3.2.3
Component: postgis Version: 3.2.x
Keywords: Cc: ryanfrench

Description (last modified by ryanfrench)

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

Change History (1)

comment:1 by ryanfrench, 2 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.