Options to rollback PostGIS upgrade

[Regina Obe]

Which version of PostGIS are you coming from again?

 

In theory, as long as your old is running a newish PostGIS 3+, it should be safe enough to just NOT run

 

SELECT postgis_extensions_upgrade();

 

If you don’t run that, then your database is just running with a newer lib file, but old scripts.  So then just installing the binaries of older should work fine.

 

One caveat, I believe we did make sure changes that caused some functions not to work, but I can’t remember what those were.

 

All I know is if you run

 

SELECT postgis_full_version();

 

And you get an error after upgrading your binaries, then not running postgis_extensions_ugprade is not an option.

 

From: Nikhil Shetty <nikhil.dba04 at gmail.com> 
Sent: Monday, February 26, 2024 3:30 AM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Options to rollback PostGIS upgrade

 

Hi Team,

 

We are looking at options available to rollback a PostGIS upgrade in case there are issues after the upgrade.

 

Apart from removing new packages and installing old ones and then restoring the database from backup , do we have any other option?

 

Thanks,

Nikhil

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