Opened 2 years ago

Closed 2 years ago

#5221 closed defect (duplicate)

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

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";
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 (4)

comment:1 by ryanfrench, 2 years ago

Description: modified (diff)

comment:2 by ryanfrench, 2 years ago

Description: modified (diff)

comment:3 by ryanfrench, 2 years ago

Description: modified (diff)

comment:4 by robe, 2 years ago

Resolution: duplicate
Status: newclosed

this is a duplicate of #5210. It's already included in the upcoming release planned for today or tomorrow.

Note: See TracTickets for help on using tickets.