RE: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

[Regina Obe]

Not sure how you ended up with an alpha2,  I had removed that in the final release thinking no one would be running with that that wasn’t building there own.

 

To fix:

UPDATE pg_extension SET extversion = 'ANY' where extname LIKE 'postgis%';

 

And then run the process again.

 

 

From: Anthony DeBarros <anthonymdebarros at gmail.com> 
Sent: Friday, November 15, 2024 7:21 AM
To: postgis-users at lists.osgeo.org
Subject: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error

 

Hi, folks,

 

I am running PostgresApp on a Mac and recently updated it to PostgreSQL version 17.1.

 

While running SELECT postgis_extensions_upgrade(); I get the following error:

 

NOTICE:  Updating extension postgis 3.5.0alpha2

 

ERROR:  extension "postgis" has no update path from version "3.5.0alpha2" to version "ANY"

CONTEXT:  SQL statement "ALTER EXTENSION postgis UPDATE TO "ANY";ALTER EXTENSION postgis UPDATE TO "3.5.0""

PL/pgSQL function postgis_extensions_upgrade(text) line 88 at EXECUTE 

 

Any advice on how to update?

 

Thanks!

Anthony DeBarros

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