[SCM] postgis.net branch website updated. clarity-final-109-gef40429
git at osgeo.org
git at osgeo.org
Wed Sep 25 21:34:47 PDT 2024
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".
The branch, website has been updated
via ef40429d00b7370351a8dd18ef6cfcafca99df06 (commit)
from 9d43277607f2b1ca665bff7a1707cbf0d70ed449 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit ef40429d00b7370351a8dd18ef6cfcafca99df06
Author: Regina Obe <lr at pcorp.us>
Date: Thu Sep 26 00:34:42 2024 -0400
Release PostGIS 3.5.0
diff --git a/config.toml b/config.toml
index c4ca06b..29bb5c7 100644
--- a/config.toml
+++ b/config.toml
@@ -164,10 +164,14 @@ enableRobotsTXT = true
[params.postgis.releases]
[params.postgis.releases.dev]
- minor = "3.5"
- dev = "3.5.0dev"
- tag = "3.5.0rc1"
+ minor = "3.6"
+ dev = "3.6.0dev"
+ tag = "3.6.0dev"
is_dev = true
+ [params.postgis.releases.35]
+ minor = "3.5"
+ dev = "3.5.1dev"
+ tag = "3.5.0"
[params.postgis.releases.34]
minor = "3.4"
dev = "3.4.4dev"
diff --git a/content/news/2024/09-26_postgis-3.5.0.md b/content/news/2024/09-26_postgis-3.5.0.md
new file mode 100644
index 0000000..2833f23
--- /dev/null
+++ b/content/news/2024/09-26_postgis-3.5.0.md
@@ -0,0 +1,164 @@
+---
+title: PostGIS 3.5.0
+layout: post
+category: news
+tags: [release, 3.5]
+author: Regina Obe
+thumbnail:
+date: "2024-09-26"
+---
+
+The PostGIS Team is pleased to release PostGIS 3.5.0!
+Best Served with [PostgreSQL 17 RC1](https://www.postgresql.org/about/news/postgresql-17-rc1-released-2926/)
+and [GEOS 3.13.0](https://github.com/libgeos/geos/releases/tag/3.13.0).
+
+This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+.
+To take advantage of all features, GEOS 3.12+ is needed.
+SFCGAL 1.4+ is needed to enable postgis_sfcgal support.
+To take advantage of all SFCGAL features, SFCGAL 1.5 is needed.
+
+### 3.5.0
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.5.0.tar.gz) [md5]({{< loc "postgis.dev_download">}}/postgis-3.5.0.tar.gz.md5)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.5.0/NEWS)
+* PDF docs: [en]({{< loc "postgis.release_docs">}}/postgis-3.5.0-en.pdf) [ja]({{< loc "postgis.release_docs">}}/postgis-3.5.0-ja.pdf), [fr]({{< loc "postgis.release_docs">}}/postgis-3.5.0-fr.pdf), [zh_Hans]({{< loc "postgis.release_docs">}}/postgis-3.5.0-zh_Hans.pdf)
+
+* HTML Online [en]({{< loc "site.root">}}docs/manual-3.5/en/) [ja]({{< loc "site.root">}}docs/manual-3.5/ja/) [fr]({{< loc "site.root">}}docs/manual-3.5/fr/) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/zh_Hans/)
+
+* Cheat Sheets:
+ * postgis: [en]({{< loc "site.root">}}docs/manual-3.5/postgis_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.5/postgis_cheatsheet-ja.html) [fr]({{< loc "site.root">}}docs/manual-3.5/postgis_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/postgis_cheatsheet-zh_Hans.html)
+ * postgis_raster: [en]({{< loc "site.root">}}docs/manual-3.5/raster_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.5/raster_cheatsheet-ja.html) [fr]({{< loc "site.root">}}docs/manual-3.5/raster_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/raster_cheatsheet-zh_Hans.html)
+ * postgis_topology: [en]({{< loc "site.root">}}docs/manual-3.5/topology_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.5/topology_cheatsheet-ja.html) [fr]({{< loc "site.root">}}docs/manual-3.5/topology_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/topology_cheatsheet-zh_Hans.html)
+ * postgis_sfcgal: [en]({{< loc "site.root">}}docs/manual-3.5/sfcgal_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.5/sfcgal_cheatsheet-ja.html) [fr]({{< loc "site.root">}}docs/manual-3.5/sfcgal_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/sfcgal_cheatsheet-zh_Hans.html)
+ * address standardizer, postgis_tiger_geocoder: [en]({{< loc "site.root">}}docs/manual-3.5/tiger_geocoder_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.5/tiger_geocoder_cheatsheet-ja.html) [fr]({{< loc "site.root">}}docs/manual-3.5/tiger_geocoder_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.5/tiger_geocoder_cheatsheet-zh_Hans.html)
+
+
+This release is a feature release that includes bug fixes since PostGIS 3.4.3, new features, and a few breaking changes.
+
+
+<!--more-->
+Many thanks to our translation teams, in particular:
+
+* Dapeng Wang, Zuo Chenwei from HighGo (Chinese Team)
+* Teramoto Ikuhiro (Japanese Team)
+* Vincent Bre from Oslandia (French Team)
+
+### Breaking Changes
+
+ - [#5546](https://trac.osgeo.org/postgis/ticket/5546), TopoGeometry <> TopoGeometry is now ambiguous, to get
+ the old behaviour, assuming your TopoGeometry objects
+ are named tg1 and tg2, use: (
+ id(tg1) <> id(tg2) OR
+ topology_id(tg1) <> topology_id(tg2) OR
+ layer_id(tg1) <> layer_id(tg2) OR
+ type(tg1) <> type(tg2)
+ ) (Sandro Santilli)
+ - [#5536](https://trac.osgeo.org/postgis/ticket/5536), comments are not anymore included in PostGIS extensions
+ (Sandro Santilli)
+ - xmllint is now required to build comments (Sandro Santilli)
+ - DocBook5 XSL is now required to build html (Sandro Santilli)
+ - [#5602](https://trac.osgeo.org/postgis/ticket/5602), Drop support for GEOS 3.6 and 3.7 (Regina Obe)
+ - [#5571](https://trac.osgeo.org/postgis/ticket/5571), Improve ST_GeneratePoints performance, but old
+ seeded pseudo random points will need to be regenerated.
+ - [#5596](https://trac.osgeo.org/postgis/ticket/5596), [GH-749](https://github.com/postgis/postgis/pull/749), Allow promoting column as an id
+ in ST_AsGeoJson(record,..).
+ Views and materialized views that use the ST_AsGeoJSON(record ..)
+ will need rebuilding to upgrade to new signature
+ (Jan Tojnar)
+ - [#5496](https://trac.osgeo.org/postgis/ticket/5496), ST_Clip all variants replaced, will require
+ rebuilding of materialized views that use them (Regina Obe)
+ - [#5659](https://trac.osgeo.org/postgis/ticket/5659), ST_DFullyWithin behaviour has changed to
+ be ST_Contains(ST_Buffer(A, R), B) (Paul Ramsey)
+ - Remove the WFS_locks extra package. (Paul Ramsey)
+ - [#5747](https://trac.osgeo.org/postgis/ticket/5747), [GH-776](https://github.com/postgis/postgis/pull/776), ST_Length: Return 0 for CurvePolygon (Dan Baston)
+ - [#5770](https://trac.osgeo.org/postgis/ticket/5770), support for GEOS 3.13 and RelateNG. Most functionality
+ remains the same, but new GEOS predicate implementation
+ has a few small changes.
+ - Boundary Node Rule relate matrices might be different when
+ using the "multi-valent end point" rule.
+ - Relate matrices for situations with invalid MultiPolygons
+ with shared boundaries might be different. Run ST_MakeValid
+ to get valid inputs to feed to the calculation.
+ - Zero length LineStrings are treated as if they are the
+ equivalent Point object.
+
+
+### Deprecated signatures
+
+ - [GH-761](https://github.com/postgis/postgis/pull/761), ST_StraightSkeleton => CG_StraightSkeleton (Loïc Bartoletti)
+ - [GT-189](https://git.osgeo.org/gitea/postgis/postgis/pulls/189), All SFCGAL functions now use the prefix CG_, with the old ones using
+ ST_ being deprecated. (Loïc Bartoletti)
+
+### New Features
+
+ - Improvements in the 'postgis' script:
+ - new command list-enabled
+ - new command list-all
+ - command upgrade upgrades all databases that need to be
+ - command status reports status of all databases
+ (Sandro Santilli)
+ - [#5742](https://trac.osgeo.org/postgis/ticket/5742), expose version of PROJ at compile time (Sandro Santilli)
+ - [#5721](https://trac.osgeo.org/postgis/ticket/5721), postgis_topology: Allow sharing sequences between different topologies (Lars Opsahl)
+ - [#5667](https://trac.osgeo.org/postgis/ticket/5667), postgis_topology: TopoGeo_LoadGeometry (Sandro Santilli)
+ - [#5055](https://trac.osgeo.org/postgis/ticket/5055), add explicit <> geometry operator to prevent non-unique
+ error with <> and != (Paul Ramsey)
+ - Add ST_HasZ/ST_HasM (Loïc Bartoletti)
+ - [GT-123](https://git.osgeo.org/gitea/postgis/postgis/pulls/123), postgis_sfcgal: CG_YMonotonePartition, CG_ApproxConvexPartition,
+ CG_GreeneApproxConvexPartition and CG_OptimalConvexPartition
+ (Loïc Bartoletti)
+ - [GT-156](https://git.osgeo.org/gitea/postgis/postgis/pulls/156), postgis_sfcgal: CG_Visibility (Loïc Bartoletti)
+ - [GT-157](https://git.osgeo.org/gitea/postgis/postgis/pulls/157), postgis_sfcgal: Add ST_ExtrudeStraightSkeleton (Loïc Bartoletti)
+ - [#5496](https://trac.osgeo.org/postgis/ticket/5496), postgis_raster: ST_Clip support for touched (Regina Obe)
+ - [GH-760](https://github.com/postgis/postgis/pull/760), postgis_sfcgal: CG_Intersection, CG_3DIntersects, CG_Intersects,
+ CG_Difference, CG_Union (and aggregate), CG_Triangulate, CG_Area,
+ CG_3DDistance, CG_Distance (Loïc Bartoletti)
+ - [#5687](https://trac.osgeo.org/postgis/ticket/5687), Don't rely on search_path to determine postgis schema
+ Fix for PG17 security change (Regina Obe)
+ - [#5705](https://trac.osgeo.org/postgis/ticket/5705), [GH-767](https://github.com/postgis/postgis/pull/767), ST_RemoveIrrelevantPointsForView (Sam Peters)
+ - [#5706](https://trac.osgeo.org/postgis/ticket/5706), [GH-768](https://github.com/postgis/postgis/pull/768), ST_RemoveSmallParts (Sam Peters)
+
+### Enhancements
+
+ - [#5550](https://trac.osgeo.org/postgis/ticket/5550), Fix upgrades from 2.x in sandboxed systems (Sandro Santilli)
+ - [#3587](https://trac.osgeo.org/postgis/ticket/3587), postgis_topology: faster load of big lines in topologies (Sandro Santilli)
+ - [#5670](https://trac.osgeo.org/postgis/ticket/5670), postgis_topology: faster ST_CreateTopoGeo (Sandro Santilli)
+ - [#5531](https://trac.osgeo.org/postgis/ticket/5531), documentation format upgraded to DocBook 5 (Sandro Santilli)
+ - [#5543](https://trac.osgeo.org/postgis/ticket/5543), allow building without documentation (Sandro Santilli)
+ - [#5596](https://trac.osgeo.org/postgis/ticket/5596), [GH-749](https://github.com/postgis/postgis/pull/749), Allow promoting column as an id
+ in ST_AsGeoJson(record,..). (Jan Tojnar)
+ - [GH-744](https://github.com/postgis/postgis/pull/744), Don't create docbook.css for the HTML manual,
+ use style.css instead (Chris Mayo)
+ - Faster implementation of point-in-poly cached index (Paul Ramsey)
+ - Improve performance of ST_GeneratePoints (Paul Ramsey)
+ - [#5361](https://trac.osgeo.org/postgis/ticket/5361), ST_CurveN, ST_NumCurves and consistency in
+ accessors on curved geometry (Paul Ramsey)
+ - [GH-761](https://github.com/postgis/postgis/pull/761), postgis_sfcgal: Add an optional parameter to CG_StraightSkeleton
+ (was ST_StraightSkeleton) to use m as a distance in result (Hannes Janetzek, Loïc Bartoletti)
+
+
+
+### Upgrading
+
+After installing the binaries or after running pg_upgrade:
+
+For PostGIS 3.4, 3.3, 3.2, 3.1, 3.0
+do below which will upgrade all your postgis extensions.
+```postgres
+SELECT postgis_extensions_upgrade();
+```
+
+
+For PostGIS 2.5 and below do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+SELECT postgis_extensions_upgrade();
+SELECT postgis_extensions_upgrade();
+```
+
+If you come across any issues, feel free to report via our [ticket tracker](https://trac.osgeo.org/postgis)
+or [mailing list](https://lists.osgeo.org/listinfo/postgis-users) with details
+
+View all [tickets for 3.5.0 milestone][1].
+
+[1]: https://trac.osgeo.org/postgis/query?status=assigned&status=closed&milestone=PostGIS+3.5.0&milestone=PostGIS+3.4.2&milestone=PostGIS+3.3.6
-----------------------------------------------------------------------
Summary of changes:
config.toml | 10 +-
content/news/2024/09-26_postgis-3.5.0.md | 164 +++++++++++++++++++++++++++++++
2 files changed, 171 insertions(+), 3 deletions(-)
create mode 100644 content/news/2024/09-26_postgis-3.5.0.md
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list