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
