Re: Eco Extension: PostGIS for Cloudberry upgraded to 3.3.2

[韩伟 <ha...@hashdata.cn>]

Thanks for your feedback! The PostGIS issue has been fixed, please refer the latest PR: https://github.com/cloudberry-contrib/postgis/pull/8.  
Thank you for reporting this issue.

Best,
Wei Han
> From: "Dianjin Wang"<wa...@gmail.com>
> Date:  Fri, Sep 26, 2025, 17:50
> Subject:  Re: Eco Extension: PostGIS for Cloudberry upgraded to 3.3.2
> To: <de...@cloudberry.apache.org>
> Thanks for your valuable feedback! I will test it later to see if I

> can reproduce the cases. Thanks again!

> 
> 
> Best,

> Dianjin Wang

> 
> On Fri, Sep 26, 2025 at 5:19 PM Ed Espino <es...@apache.org> wrote:

> >

> > Additionally, the following SQL from the postgis cloudberry documentation

> > is also generating a postgres crash:

> >

> > -- Selects the name and geopoint fields from the geotest table, but

> > converts the geopoint field to standard text (WKT) format using the

> > ST_AsText function.

> >

> > SELECT name,ST_AsText(geopoint) FROM geotest;

> >

> > -=e

> >

> > On Fri, Sep 26, 2025 at 1:55 AM Ed Espino <es...@apache.org> wrote:

> >

> > > Following the PostGIS 3.3.2 for Apache Cloudberry documentation, I am

> > > encountering a *postgres crash* when using either the main or REL_2_STABLE

> > > branches of Cloudberry.

> > >

> > > I ran into the issue quickly when attempting to run the PostGIS test

> > > suite. The following query will reliably trigger the crash:

> > >

> > > SELECT ST_AsText(ST_Buffer(ST_GeomFromText('POINT(0 0)', 4326), 0.1));

> > >

> > > I will be entering a GitHub issue to begin tracking this. I wanted to

> > > share here to give others in the community an early heads-up.

> > >

> > > Attached to this email is a file

> > > (postgis-crash-analysis-20250926-013414.txt) with core file analysis info

> > > for reference

> > > OS: Rocky Linux 9.6 (Blue Onyx)

> > >

> > > -=e

> > >

> > > On Tue, Sep 23, 2025 at 7:04 AM Dianjin Wang <wa...@gmail.com>

> > > wrote:

> > >

> > >> Hi all,

> > >>

> > >> We are pleased to announce that PostGIS for Cloudberry has been

> > >> upgraded from version 2.5 to 3.3.2.

> > >>

> > >> The updated source code can be found here:

> > >> - https://github.com/cloudberry-contrib/postgis

> > >>

> > >> We have also refreshed the installation guide to help you get started:

> > >> - https://cloudberry.apache.org/docs/advanced-analytics/postgis

> > >>

> > >> This upgrade brings modern PostGIS features and ensures that

> > >> Cloudberry users can leverage the newer geospatial capabilities.

> > >>

> > >> Please note that this is a project in the Cloudberry ecosystem and is

> > >> not maintained by the Apache Cloudberry PPMC.

> > >>

> > >> We encourage you to try it out and share your feedback with the community.

> > >>

> > >> Best,

> > >> Dianjin Wang

> > >>

> > >> ---------------------------------------------------------------------

> > >> To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org

> > >> For additional commands, e-mail: dev-help@cloudberry.apache.org

> > >>

> > >>

> 
> ---------------------------------------------------------------------

> To unsubscribe, e-mail: dev-unsubscribe@cloudberry.apache.org

> For additional commands, e-mail: dev-help@cloudberry.apache.org
>