Jim,
Sorry I had missed the thread Roxanne had written. So you already ran twice SELECT postgis_extensions_upgrade(); SELECT postgis_extensions_upgrade(); And still shows raster is UNPACKAGED. If you did delete some raster functions in panic, then I think that would prevent it from being upgraded. You want to first make sure you don’t have raster tables running the below query should return no records. SELECT * FROM raster_columns; Easy fix especially if you don’t need raster support, is to run the uninstall raster script I had attached in that mailing list thread Roxanne pointed to https://lists.osgeo.org/pipermail/postgis-users/attachments/20200529/e32c5d8c/attachment.obj That should cleanly get rid of all remnants of raster. Hope that helps, Regina From: postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Roxanne Reid-Bennett Sent: Monday, January 23, 2023 9:29 PM To: postgis-users@lists.osgeo.org Subject: Re: [postgis-users] Upgrade 12->13 stuck due to postgis / raster issue Jim, I did a search on this phrase: raster procs from "2.5.2 r17328" need upgrade I found a post from Regina from 2020 moving from 2.5.2 to 3. It might illumine a bit. https://lists.osgeo.org/pipermail/postgis-users/2020-May/044225.html And this one for someone who had 100% control of their PG hardware from last fall. https://groups.google.com/g/postgis-users/c/26iNuhXFHgg And this one from the AWS forums https://repost.aws/questions/QUEk9HG5x3Qq6sEB3lVmynUw/upgrade-from-postgres-12-7-r-1-to-13-3-r-1-stuck which references this: https://stackoverflow.com/questions/42634626/postgresql-upgrade-on-amazon-rds-blocked-by-postgis-version which uses ALTER EXTENSION postgis UPDATE; The observation in the last post about waiting overnight and things "magically being fixed", I saw during our dry run, not the production run, but definitely during the dry run. Their observation about rebooting the PG server between upgrades isn't totally "off" either. Posting in the AWS Forums might get some help from inside Amazon. Or, if you have any level of support from AWS that would allow you get someone to "poke/prod" on disk, you might get a fix. Migrating the data is "of course" a last resort, but at least possible. Given my lack of knowledge of the upgrade steps, I've done what I can. Good luck. Roxanne
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
