Re: Updating PostGIS from 3.5.0alpha2 —> 3.5.0 err or

 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 <[email protected]> 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 <[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
>