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 <[email protected]> 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 <[email protected]> > 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: [email protected] >> For additional commands, e-mail: [email protected] >> >>
