<html><body><div dir="ltr">
Thanks! Worked like a charm.</div><div dir="ltr"><br></div><div dir="ltr">I think the makers of Postgres App included the alpha version in a beta of 17 at some point.</div><div dir="ltr"><br></div><div dir="ltr"><br></div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Nov 15, 2024 at 10:36:30 AM, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" type="cite">
<div><div><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"></div><div lang="EN-US" link="#467886" vlink="#96607D" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt">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.</span></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt">To fix:</span></p><p class="MsoNormal"><span style="font-size:11.0pt">UPDATE pg_extension SET extversion = 'ANY' where extname LIKE 'postgis%';</span></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt">And then run the process again.</span></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Anthony DeBarros <<a href="mailto:anthonymdebarros@gmail.com">anthonymdebarros@gmail.com</a>> <br><b>Sent:</b> Friday, November 15, 2024 7:21 AM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Updating PostGIS from 3.5.0alpha2 —> 3.5.0 error</span></p></div></div><p class="MsoNormal"> </p><div><div><p class="MsoNormal">Hi, folks,</p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">I am running PostgresApp on a Mac and recently updated it to PostgreSQL version 17.1.</p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">While running SELECT postgis_extensions_upgrade(); I get the following error:</p></div><div><p class="MsoNormal"> </p></div></div><div><div><p class="MsoNormal">NOTICE: Updating extension postgis 3.5.0alpha2</p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">ERROR: extension "postgis" has no update path from version "3.5.0alpha2" to version "ANY"</p></div><div><p class="MsoNormal">CONTEXT: SQL statement "ALTER EXTENSION postgis UPDATE TO "ANY";ALTER EXTENSION postgis UPDATE TO "3.5.0""</p></div><div><p class="MsoNormal">PL/pgSQL function postgis_extensions_upgrade(text) line 88 at EXECUTE </p></div></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">Any advice on how to update?</p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">Thanks!</p></div><div><p class="MsoNormal">Anthony DeBarros</p></div></div></div></div></div>
</blockquote>
</div></body></html>