Database crash when creating raster_in function

[Nikhil Shetty]

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 <lr at 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.dba04 at gmail.com>
> *Sent:* Saturday, March 16, 2024 10:55 AM
> *To:* PostGIS Users Discussion <postgis-users at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240317/fe746b2d/attachment.htm>