Options to rollback PostGIS upgrade

[Nikhil Shetty]

Hi Regina,

We are upgrading from 3.1.2 to 3.3.3.

So, after we run below command the only option to rollback to previous
PostGIS version is to install old binaries and restore data from backup?

SELECT postgis_extensions_upgrade();

Thanks,
Nikhil

On Mon, 26 Feb 2024 at 20:23, Regina Obe <lr at pcorp.us> wrote:

> 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/4ee2df28/attachment.htm>