Update postgis in a replicated PostgreSQL 12 database now with postgis-3

[Regina Obe]

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.hardy at sabstt.com> 
Sent: Thursday, September 5, 2024 12:26 PM
To: Andrew Hardy <andrew.hardy at sabstt.com>; postgis-users at lists.osgeo.org; strk at 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 <strk at kbt.io <mailto:strk at 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;

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240905/c43f0f7c/attachment.htm>