<div dir="auto">I am  are using raster extension </div><div dir="auto"><br></div><div dir="auto">The creation of raster_in function breaks on PG15 as well, JFYI, I have created package for 3.3.5 on rhel7(this is not available in Postgres repo)</div><div dir="auto"><br></div><div dir="auto">Will the fix given in <div><span style="font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-size:10pt;font-family:arial,sans-serif;background-color:rgba(0,0,0,0);border-color:rgb(0,0,0);color:rgb(0,0,0)"> </span><span style="font-size:16px;font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none;font-family:-apple-system,helveticaneue;background-color:rgba(0,0,0,0);border-color:rgb(34,34,34);color:rgb(34,34,34)"><a href="https://trac.osgeo.org/postgis/ticket/5277" style="font-family:-apple-system,helveticaneue;background-color:rgba(0,0,0,0);border-color:rgb(66,133,244);color:rgb(66,133,244)">https://trac.osgeo.org/postgis/ticket/5277</a></span></div> solve the issue? if yes, I can add the same fix and create new rpms for 3.3.5 on rhel7</div><div dir="auto"><br></div><div dir="auto">Thanks,</div><div dir="auto">Nikhil</div><div dir="auto"><br></div><div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sun, 17 Mar 2024 at 10:07, 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-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)"><div lang="EN-US" link="blue" vlink="purple" style="overflow-wrap: break-word;"><div class="m_-1759507066092208747WordSection1"><p class="MsoNormal"><span style="font-size:11pt">Yap that was fixed in PostGIS 3.3.3.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">The change there was to support a change in PG16, so you shouldn’t need it for upgrading from PG13 to PG15.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">Are you using postgis_raster or you just have it installed?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt">If you don’t need postgis_raster, I would suggest uninstalling it before upgrading. <u></u><u></u></span></p></div></div><div lang="EN-US" link="blue" vlink="purple" style="overflow-wrap: break-word;"><div class="m_-1759507066092208747WordSection1"><p class="MsoNormal"><span style="font-size:11pt"><u></u> <u></u></span></p><div style="border-width:medium medium medium 1.5pt;border-style:none none none solid;padding:0in 0in 0in 4pt;border-color:currentcolor currentcolor currentcolor blue"><div><div style="border-width:1pt medium medium;border-style:solid none none;padding:3pt 0in 0in;border-color:rgb(225,225,225) currentcolor currentcolor"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> Nikhil Shetty <<a href="mailto:nikhil.dba04@gmail.com" target="_blank" style="font-family:Calibri,sans-serif">nikhil.dba04@gmail.com</a>> <br><b style="font-family:Calibri,sans-serif">Sent:</b> Saturday, March 16, 2024 10:55 AM<br><b style="font-family:Calibri,sans-serif">To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" style="font-family:Calibri,sans-serif">postgis-users@lists.osgeo.org</a>><br><b style="font-family:Calibri,sans-serif">Subject:</b> Database crash when creating raster_in function<u style="font-family:Calibri,sans-serif"></u><u style="font-family:Calibri,sans-serif"></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi Team,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I am trying to upgrade the postgres database from PG13 to PG15. pg_upgrade is crashing with below error when creating the raster_in function<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><blockquote style="border-width:medium medium medium 1pt;border-style:none none none solid;padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in;border-color:currentcolor currentcolor currentcolor rgb(204,204,204)"><p class="MsoNormal">pg_restore: creating FUNCTION "public.raster_in("cstring")"<br>pg_restore: while PROCESSING TOC:<br>pg_restore: from TOC entry 394; 1255 16439 FUNCTION raster_in("cstring") postgres<br>pg_restore: error: could not execute query: server closed the connection unexpectedly<br>This probably means the server terminated abnormally<br>before or while processing the request.<br>Command was: CREATE FUNCTION "public"."raster_in"("cstring") RETURNS "public"."raster"<br>    LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE<br>    AS '$libdir/postgis_raster-3', 'RASTER_in';<u></u><u></u></p></blockquote><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;font-family:Menlo,serif;color:black"><u style="font-family:Menlo,serif"></u> <u style="font-family:Menlo,serif"></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;font-family:Menlo,serif;color:black"><u style="font-family:Menlo,serif"></u> <u style="font-family:Menlo,serif"></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">PostGIS version : <b style="font-family:Arial,sans-serif">3.3.5</b></span><span style="font-size:10pt;color:black"><u></u><u></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;color:black"><u></u> <u></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;font-family:Arial,sans-serif;color:black">This looks similar to the issue mentioned in </span><span style="color:rgb(34,34,34)"><a href="https://trac.osgeo.org/postgis/ticket/5277" target="_blank">https://trac.osgeo.org/postgis/ticket/5277</a>. Is this fixed in 3.3.5 ?</span><span style="font-size:10pt;color:black"><u></u><u></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="font-size:10pt;color:black"><u></u> <u></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="color:rgb(34,34,34)">Thanks,</span><span style="font-size:10pt;color:black"><u></u><u></u></span></p><p style="margin:0in;font-stretch:normal;font-size-adjust:none;font-kerning:auto;font-variant-alternates:normal;font-variant-ligatures:normal;font-variant-numeric:normal;font-variant-east-asian:normal;font-feature-settings:normal"><span style="color:rgb(34,34,34)">Nikhil</span><span style="font-size:10pt;color:black"><u></u><u></u></span></p></div></div></div></div></div></blockquote></div></div>