Thanks! Worked like a charm. I think the makers of Postgres App included the alpha version in a beta of 17 at some point.
On Nov 15, 2024 at 10:36:30 AM, Regina Obe <l...@pcorp.us> wrote: > 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 <anthonymdebar...@gmail.com> > *Sent:* Friday, November 15, 2024 7:21 AM > *To:* postgis-users@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 >
