Yes. Running twice second run is supposed to repackage postgis_raster.
If the repackaging works, then to drop raster just do: DROP EXTENSION postgis_raster; If drop extension works, no need to run that uninstall_rtpostgis.sql script. If it doesn’t work then you need to run uninstall_rtpostgis.sql to remove. From: Andrew Hardy <andrew.ha...@sabstt.com> Sent: Thursday, September 5, 2024 12:26 PM To: Andrew Hardy <andrew.ha...@sabstt.com>; postgis-users@lists.osgeo.org; s...@kbt.io Subject: Re: Update postgis in a replicated PostgreSQL 12 database now with postgis-3 Sandro, Thanks. To be completely clear then Run SELECT postgis_extensions_upgrade(); twice anyway Even if one ultimately hopes to end up running https://postgis.net/stuff/uninstall_rtpostgis.sql right? On Thu, 5 Sept 2024 at 15:15, Sandro Santilli <s...@kbt.io <mailto:s...@kbt.io> > wrote: On Thu, Sep 05, 2024 at 09:24:10AM +0100, Andrew Hardy wrote: > SELECT postgis_extensions_upgrade(); > > -- I have not yet run this (neither once nor twice) - I was in the process > in my earlier post of discussing if it would still work given my first > mistake Please run it, then report back. --strk;
