I am are using raster extension 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)
Will the fix given in https://trac.osgeo.org/postgis/ticket/5277 solve the issue? if yes, I can add the same fix and create new rpms for 3.3.5 on rhel7 Thanks, Nikhil On Sun, 17 Mar 2024 at 10:07, Regina Obe <l...@pcorp.us> wrote: > Yap that was fixed in PostGIS 3.3.3. > > The change there was to support a change in PG16, so you shouldn’t need it > for upgrading from PG13 to PG15. > > > > Are you using postgis_raster or you just have it installed? > > > > If you don’t need postgis_raster, I would suggest uninstalling it before > upgrading. > > > > *From:* Nikhil Shetty <nikhil.db...@gmail.com> > *Sent:* Saturday, March 16, 2024 10:55 AM > *To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org> > *Subject:* Database crash when creating raster_in function > > > > Hi Team, > > > > 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 > > > > pg_restore: creating FUNCTION "public.raster_in("cstring")" > pg_restore: while PROCESSING TOC: > pg_restore: from TOC entry 394; 1255 16439 FUNCTION raster_in("cstring") > postgres > pg_restore: error: could not execute query: server closed the connection > unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > Command was: CREATE FUNCTION "public"."raster_in"("cstring") RETURNS > "public"."raster" > LANGUAGE "c" IMMUTABLE STRICT PARALLEL SAFE > AS '$libdir/postgis_raster-3', 'RASTER_in'; > > > > > > PostGIS version : *3.3.5* > > > > This looks similar to the issue mentioned in > https://trac.osgeo.org/postgis/ticket/5277. Is this fixed in 3.3.5 ? > > > > Thanks, > > Nikhil >