[SCM] postgis.net branch website updated. clarity-final-149-g9f98ec5
git at osgeo.org
git at osgeo.org
Tue Sep 2 00:20:16 PDT 2025
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 9f98ec548ba162c55a9d01be21e97288b22cab59 (commit)
from afda6b5d862fbbddf4c4607f60f26873dae779b9 (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 9f98ec548ba162c55a9d01be21e97288b22cab59
Author: Regina Obe <lr at pcorp.us>
Date: Tue Sep 2 03:19:35 2025 -0400
PostGIS 3.6.0 release
diff --git a/config.toml b/config.toml
index 5acdd42..7c714ac 100644
--- a/config.toml
+++ b/config.toml
@@ -154,7 +154,7 @@ enableRobotsTXT = true
[params.postgis]
- version = "3.5.3"
+ version = "3.6.0"
release_docs = "https://download.osgeo.org/postgis/docs"
release_source = "https://download.osgeo.org/postgis/source"
release_notes = "https://git.osgeo.org/gitea/postgis/postgis/raw/tag"
@@ -170,8 +170,8 @@ enableRobotsTXT = true
is_dev = true
[params.postgis.releases.36]
minor = "3.6"
- dev = "3.6.0dev"
- tag = "3.6.0rc2"
+ dev = "3.6.1dev"
+ tag = "3.6.0"
[params.postgis.releases.35]
minor = "3.5"
dev = "3.5.4dev"
diff --git a/content/news/2025/09-02_postgis-3.6.0.md b/content/news/2025/09-02_postgis-3.6.0.md
new file mode 100644
index 0000000..a1e4cd1
--- /dev/null
+++ b/content/news/2025/09-02_postgis-3.6.0.md
@@ -0,0 +1,110 @@
+---
+title: PostGIS 3.6.0
+layout: post
+category: news
+tags: [release, 3.6]
+author: Regina Obe
+thumbnail:
+date: "2025-09-02"
+---
+
+The PostGIS Team is pleased to release PostGIS 3.6.0!
+Best Served with [PostgreSQL 18 Beta3](https://www.postgresql.org/about/news/postgresql-176-1610-1514-1419-1322-and-18-beta-3-released-3118/)
+and recently released [GEOS 3.14.0](https://libgeos.org/posts/2025-08-21-geos-3-14-released/).
+
+This version requires PostgreSQL 12 - 18beta3, GEOS 3.8 or higher, and Proj 6.1+.
+To take advantage of all features, GEOS 3.14+ is needed.
+To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.
+
+### 3.6.0
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.6.0.tar.gz) [md5]({{< loc "postgis.dev_download">}}/postgis-3.6.0.tar.gz.md5)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.6.0/NEWS)
+* HTML Online [en]({{< loc "site.root">}}docs/manual-3.6/en/) [ja]({{< loc "site.root">}}docs/manual-3.6/ja/) [sv]({{< loc "site.root">}}docs/manual-3.6/sv/) [fr]({{< loc "site.root">}}docs/manual-3.6/fr/) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/zh_Hans/)
+* PDF docs: [en]({{< loc "postgis.dev_download">}}/postgis-3.6-en.pdf) [ja]({{< loc "postgis.dev_download">}}/postgis-3.6-ja.pdf), [sv]({{< loc "postgis.dev_download">}}/postgis-3.6-sv.pdf), [zh_Hans]({{< loc "postgis.dev_download">}}/postgis-3.6-zh_Hans.pdf), [fr]({{< loc "postgis.dev_download">}}/postgis-3.6-fr.pdf)
+
+* Cheat Sheets:
+ * postgis: [en]({{< loc "site.root">}}docs/manual-3.6/postgis_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.6/postgis_cheatsheet-ja.html) [sv]({{< loc "site.root">}}docs/manual-3.6/postgis_cheatsheet-sv.html) [fr]({{< loc "site.root">}}docs/manual-3.6/postgis_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/postgis_cheatsheet-zh_Hans.html)
+ * postgis_raster: [en]({{< loc "site.root">}}docs/manual-3.6/raster_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.6/raster_cheatsheet-ja.html) [sv]({{< loc "site.root">}}docs/manual-3.6/raster_cheatsheet-sv.html) [fr]({{< loc "site.root">}}docs/manual-3.6/raster_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/raster_cheatsheet-zh_Hans.html)
+ * postgis_topology: [en]({{< loc "site.root">}}docs/manual-3.6/topology_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.6/topology_cheatsheet-ja.html) [sv]({{< loc "site.root">}}docs/manual-3.6/topology_cheatsheet-sv.html) [fr]({{< loc "site.root">}}docs/manual-3.6/topology_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/topology_cheatsheet-zh_Hans.html)
+ * postgis_sfcgal: [en]({{< loc "site.root">}}docs/manual-3.6/sfcgal_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.6/sfcgal_cheatsheet-ja.html) [sv]({{< loc "site.root">}}docs/manual-3.6/sfcgal_cheatsheet-sv.html) [fr]({{< loc "site.root">}}docs/manual-3.6/sfcgal_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/sfcgal_cheatsheet-zh_Hans.html)
+ * address standardizer, postgis_tiger_geocoder: [en]({{< loc "site.root">}}docs/manual-3.6/tiger_geocoder_cheatsheet-en.html) [ja]({{< loc "site.root">}}docs/manual-3.6/tiger_geocoder_cheatsheet-ja.html) [sv]({{< loc "site.root">}}docs/manual-3.6/tiger_geocoder_cheatsheet-sv.html) [fr]({{< loc "site.root">}}docs/manual-3.6/tiger_geocoder_cheatsheet-fr.html) [zh_Hans]({{< loc "site.root">}}docs/manual-3.6/tiger_geocoder_cheatsheet-zh_Hans.html)
+
+This release includes bug fixes since PostGIS 3.5.3 and new features.
+
+<!--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
+
+ - [#5799](https://trac.osgeo.org/postgis/ticket/5799), make ST_TileEnvelope clips envelopes to tile plane extent (Paul Ramsey)
+ - [#5829](https://trac.osgeo.org/postgis/ticket/5829), remove constraint checking from geometry_columns view (Paul Ramsey)
+ - [#3373](https://trac.osgeo.org/postgis/ticket/3373), [GT-255](https://git.osgeo.org/gitea/postgis/postgis/pulls/255), [topology] Support for upgrading domains (Ayo Adesugba, U.S. Census Bureau)
+ - [GT-252](https://git.osgeo.org/gitea/postgis/postgis/pulls/252), ST_NumGeometries/ST_GeometryN treat TIN and PolyhedralSurface as unitary geometries,
+ use ST_NumPatches/ST_PatchN for patch access (Loïc Bartoletti)
+ - [#3110](https://trac.osgeo.org/postgis/ticket/3110), [GT-242](https://git.osgeo.org/gitea/postgis/postgis/pulls/242) [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
+ - [#5359](https://trac.osgeo.org/postgis/ticket/5359), [#5897](https://trac.osgeo.org/postgis/ticket/5897), [GT-260](https://git.osgeo.org/gitea/postgis/postgis/pulls/260) [tiger_geocoder] Use @extschema:extension@ for PG >= 16
+ to schema qualify dependent extensions, switch to use typmod for tiger tables
+ (Regina Obe)
+
+### Deprecated / Removed signatures
+
+ - [#3110](https://trac.osgeo.org/postgis/ticket/3110), [GT-242](https://git.osgeo.org/gitea/postgis/postgis/pulls/242), [topology] numerous topology functions that accepted integer
+ replaced with bigint versions to support both integer and bigint inputs
+ (Ayo Adesugba, U.S. Census Bureau)
+ - [#5498](https://trac.osgeo.org/postgis/ticket/5498) Drop st_approxquantile(raster, double precision), wasn't usable as it triggered
+ is not unique error when used (Regina Obe)
+
+### New Features
+
+ - [GH-803](https://github.com/postgis/postgis/pull/803), [sfcgal] ADD CG_Simplify function (Loïc Bartoletti)
+ - [GH-805](https://github.com/postgis/postgis/pull/805), [sfcgal] Add M support for SFCGAL >= 1.5.0 (Loïc Bartoletti)
+ - [GH-801](https://github.com/postgis/postgis/pull/801), [sfcgal] ADD CG_3DAlphaWrapping function (Jean Felder)
+ - [#5894](https://trac.osgeo.org/postgis/ticket/5894), [topology] TotalTopologySize (Sandro Santilli)
+ - [#5890](https://trac.osgeo.org/postgis/ticket/5890), [topology] ValidateTopologyPrecision, MakeTopologyPrecise (Sandro Santilli)
+ - [#5861](https://trac.osgeo.org/postgis/ticket/5861), [topology] Add --drop-topology switch to pgtopo_import (Sandro Santilli)
+ - [#1247](https://trac.osgeo.org/postgis/ticket/1247), [raster] ST_AsRasterAgg (Sandro Santilli)
+ - [#5784](https://trac.osgeo.org/postgis/ticket/5784), [GT-223](https://git.osgeo.org/gitea/postgis/postgis/pulls/223) Export circ_tree_distance_tree_internal for mobilitydb use
+ (Maxime Schoemans)
+ - [GT-228](https://git.osgeo.org/gitea/postgis/postgis/pulls/228), [sfcgal] Add new functions (Scale, Translate, Rotate, Buffer 3D and
+ Straight Skeleton Partition) from SFCGAL 2 (Loïc Bartoletti)
+ - [raster] New GUC postgis.gdal_cpl_debug, enables GDAL debugging messages
+ and routes them into the PostgreSQL logging system. (Paul Ramsey)
+ - [#5841](https://trac.osgeo.org/postgis/ticket/5841), Change interrupt handling to remove use of pqsignal to support PG 18 (Paul Ramsey)
+ - Add ST_CoverageClean to edge match and gap remove polygonal
+ coverages (Paul Ramsey) from GEOS 3.14 (Martin Davis)
+ - [#3110](https://trac.osgeo.org/postgis/ticket/3110), [GT-242](https://git.osgeo.org/gitea/postgis/postgis/pulls/242) [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
+ - [raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
+ - [#5963](https://trac.osgeo.org/postgis/ticket/5963), [raster] add ST_IntersectionFractions - Requires GEOS 3.14 (Paul Ramsey)
+ - [#5971](https://trac.osgeo.org/postgis/ticket/5971), Option to build --without-tiger (Regina Obe)
+
+### Upgrading
+
+After installing the binaries or after running pg_upgrade:
+
+For PostGIS 3.6, 3.5, 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.6.0 milestone][1].
+
+[1]: https://trac.osgeo.org/postgis/query?status=assigned&status=closed&milestone=PostGIS+3.6.0&milestone=PostGIS+3.5.4
-----------------------------------------------------------------------
Summary of changes:
config.toml | 6 +-
content/news/2025/09-02_postgis-3.6.0.md | 110 +++++++++++++++++++++++++++++++
2 files changed, 113 insertions(+), 3 deletions(-)
create mode 100644 content/news/2025/09-02_postgis-3.6.0.md
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list