RE: Updating PostGIS from 3.5.0a lpha2 —> 3.5.0 error

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 <[email protected]> 
Sent: Friday, November 15, 2024 7:21 AM
To: [email protected]
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