<div dir="auto">Sounds good! Thanks for the follow up.</div><div dir="auto"><br></div><div dir="auto">Derek</div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Oct 8, 2024 at 13:37 Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word"><div class="m_-936023335321599180WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt">We haven’t decided on a patch version release date.  I’m thinking a little before PostgreSQL 17.1 would be a good time, to catch the bulk of new folks upgrading.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt">I’ve ticketed the issue here -  <a href="https://trac.osgeo.org/postgis/ticket/5791" target="_blank">https://trac.osgeo.org/postgis/ticket/5791</a> and will address this week.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt">Thanks for the report,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt">Regina<u></u><u></u></span></p></div></div><div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word"><div class="m_-936023335321599180WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt"><u></u> <u></u></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"> Kered <<a href="mailto:dereksunpublic@gmail.com" target="_blank">dereksunpublic@gmail.com</a>> <br><b>Sent:</b> Tuesday, October 8, 2024 3:46 PM<br><b>To:</b> Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>><br><b>Subject:</b> Re: Failure during Postgres major version upgrade due to deprecated long_xact funcs<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi Regina,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">After adding those two to postgis_legacy.c and rebuilding it, now upgrade can complete. Thanks for the help!<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="m_-936023335321599180gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">Upgrade Complete</span></span><span style="font-family:"Monaco",serif"><u></u><u></u></span></p><p class="m_-936023335321599180gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">----------------</span></span><span style="font-family:"Monaco",serif"><u></u><u></u></span></p><p class="m_-936023335321599180gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">Optimizer statistics are not transferred by pg_upgrade.</span></span><span style="font-family:"Monaco",serif"><u></u><u></u></span></p><p class="m_-936023335321599180gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">Once you start the new server, consider running:</span></span><span style="font-family:"Monaco",serif"><u></u><u></u></span></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">May I know when the new patch version will be released? <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Derek<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">On Tue, Oct 8, 2024 at 12:14<span style="font-family:"Arial",sans-serif"> </span>PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<u></u><u></u></p></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><div><div><p class="MsoNormal"><span style="font-size:11.0pt">Thanks for the alert.  I suspect we forgot to add that function to postgis_legacy, so that needs to be done.  We’ll do that in next 3.4. patch update.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt">For now I recommend before upgrading (especially with pg_upgrade) dropping it in the extension.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt">So </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">ALTER EXTENSION "postgis" DROP FUNCTION "public"."checkauthtrigger"() CASCADE;</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white"> </span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in"><span style="font-family:"Monaco",serif"> </span><u></u><u></u></p><p class="MsoNormal" style="font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-size:11.0pt"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt"> </span><u></u><u></u></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"> Kered <<a href="mailto:dereksunpublic@gmail.com" target="_blank">dereksunpublic@gmail.com</a>> <br><b>Sent:</b> Tuesday, October 8, 2024 12:23 PM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Failure during Postgres major version upgrade due to deprecated long_xact funcs</span><u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><p class="MsoNormal">Hi there,<u></u><u></u></p><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">I saw postgres upgrade failure with following message (pg16.1 to 17.0, postgis 3.4.0 to postgis 3.5.0)<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: creating FUNCTION "public.checkauth("text", "text", "text")"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: creating COMMENT "public.FUNCTION "checkauth"("text", "text", "text")"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: creating FUNCTION "public.checkauthtrigger()"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: while PROCESSING TOC:</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: from TOC entry 558; 1255 18735 FUNCTION checkauthtrigger() pguser</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">pg_restore: error: could not execute query: ERROR:</span></span><span class="m_-936023335321599180m8611334095636051211gmail-apple-converted-space"><span style="font-family:"Monaco",serif;color:black;background:white">  </span></span><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">could not find function "check_authorization" in file "/local/home/pguser/temp/local_pg/installs/pg170/lib/postgresql/postgis-3.so"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">Command was: CREATE FUNCTION "public"."checkauthtrigger"() RETURNS "trigger"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-apple-converted-space"><span style="font-family:"Monaco",serif;color:black;background:white">    </span></span><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">LANGUAGE "c"</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-apple-converted-space"><span style="font-family:"Monaco",serif;color:black;background:white">    </span></span><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">AS '$libdir/postgis-3', 'check_authorization';</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p2" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal;min-height:21px"><span style="font-family:"Monaco",serif"> </span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">-- For binary upgrade, handle extension membership the hard way</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">ALTER EXTENSION "postgis" ADD FUNCTION "public"."checkauthtrigger"();</span></span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-family:"Monaco",serif"> </span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white">(same for </span></span><span style="font-size:11.0pt;font-family:Consolas;color:black;background:#f7f7f7">GetTransactionID</span><span style="font-family:"Monaco",serif;color:black">)</span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-family:"Monaco",serif"> </span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Arial",sans-serif;color:black;background:white">I saw a previous ticket</span></span><span class="m_-936023335321599180m8611334095636051211gmail-s1"><span style="font-family:"Monaco",serif;color:black;background:white"> </span></span><span style="font-family:"Arial",sans-serif"><a href="https://trac.osgeo.org/postgis/ticket/5723" target="_blank">https://trac.osgeo.org/postgis/ticket/5723</a>  which tried to drop it already, but I still see this. Is this expected or something that was missed during testing?</span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"> <u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-family:"Arial",sans-serif">Best,</span><u></u><u></u></p><p class="m_-936023335321599180m8611334095636051211gmail-p1" style="margin:0in;font-variant-numeric:normal;font-variant-east-asian:normal;font-variant-alternates:normal;font-size-adjust:none;font-kerning:auto;font-feature-settings:normal;font-stretch:normal"><span style="font-family:"Arial",sans-serif">Derek</span><u></u><u></u></p></div></div></div></div></div></div></blockquote></div></div></div></div></blockquote></div></div>