[postgis-users] Postgis 3.1.0 st_makevalid crashes the PostgreSQL Server

Fatih Sazan fatihsazan01 at gmail.com
Mon Jan 25 02:52:06 PST 2021


my postgis verison details:
SELECT postgis_full_version();

POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.9.0-CAPI-1.16.2"
PROJ="7.2.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0"
WAGYU="0.5.0 (Internal)" (core procs from "3.1.0alpha2 b6f415d" need
upgrade) TOPOLOGY (topology procs from "3.1.0alpha2 b6f415d" need upgrade)

Bjornar Skinnes <bjornar_skinnes at trimble.com>, 25 Oca 2021 Pzt, 11:40
tarihinde şunu yazdı:

> postgis/postgis:latest image today.  So I also could reproduce this error.
> fyi.
> POSTGIS="3.1.0 5e2af69" [EXTENSION] PGSQL="130" GEOS="3.7.1-CAPI-1.11.1
> 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" LIBXML="2.9.4"
> LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" WAGYU="0.5.0 (Internal)" TOPOLOGY
>
> man. 25. jan. 2021 kl. 09:35 skrev Sandro Santilli <strk at kbt.io>:
>
>> On Mon, Jan 25, 2021 at 10:19:42AM +0300, Fatih Sazan wrote:
>> > When I run my code running on PostGIS version 2.5, I don't get an error
>> but
>> > when I run it on 3.1 it the server gives an error and enters the
>> recovery
>> > mode every time.
>>
>> > Operating System: CentOS Linux 8
>> > CPE OS Name: cpe:/o:centos:centos:8
>> > Kernel: Linux 4.18.0-193.28.1.el8_2.x86_64
>> > Architecture: x86-64
>> >
>> > postgresql-13
>> > extension : postgis vers. 3.1.0
>>
>> This should be fixed by upgrading GEOS.
>> What version of GEOS are you using ?
>> It should be reported by:
>>
>>   SELECT postgis_full_version();
>>
>> --strk;
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210125/10a1b8d8/attachment.html>


More information about the postgis-users mailing list