<div dir="ltr">Hi Team,<br><div><br></div><div>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</div><div><br></div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span style="font-variant-ligatures:no-common-ligatures">pg_restore: creating FUNCTION "public.raster_in("cstring")"<br></span><span style="font-variant-ligatures:no-common-ligatures">pg_restore: while PROCESSING TOC:<br></span><span style="font-variant-ligatures:no-common-ligatures">pg_restore: from TOC entry 394; 1255 16439 FUNCTION raster_in("cstring") postgres<br></span><span style="font-variant-ligatures:no-common-ligatures">pg_restore: error: could not execute query: server closed the connection unexpectedly<br></span><span style="font-variant-ligatures:no-common-ligatures">This probably means the server terminated abnormally<br></span><span style="font-variant-ligatures:no-common-ligatures">before or while processing the request.<br></span><span style="font-variant-ligatures:no-common-ligatures">Command was: CREATE FUNCTION "public"."raster_in"("cstring") RETURNS "public"."raster"<br></span><span style="font-variant-ligatures:no-common-ligatures"><span>    </span>LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE<br></span><span style="font-variant-ligatures:no-common-ligatures"><span>    </span>AS '$libdir/postgis_raster-3', 'RASTER_in';</span></blockquote>







<p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;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;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height:normal;font-family:Menlo;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;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="arial, sans-serif">PostGIS version : <b>3.3.5</b></font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><span style="font-variant-ligatures:no-common-ligatures"><font face="arial, sans-serif"><b><br></b></font></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><font face="arial, sans-serif">This looks similar to the issue mentioned in </font><span style="font-size:small;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></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><span style="font-size:small;color:rgb(34,34,34)"><br></span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><span style="font-size:small;color:rgb(34,34,34)">Thanks,</span></p><p style="margin:0px;font-stretch:normal;font-size:13px;line-height: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;color:rgb(0,0,0)"><span style="font-size:small;color:rgb(34,34,34)">Nikhil</span></p></div></div>