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 Initial Version
| Reported by: | ryanfrench | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 3.2.3 |
| Component: | postgis | Version: | 3.2.x |
| Keywords: | Cc: | ryanfrench |
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
