PostGIS 3.6.0

The PostGIS Team is pleased to release PostGIS 3.6.0! Best Served with PostgreSQL 18 Beta3 and recently released GEOS 3.14.0.

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.

• source download md5

• NEWS

• HTML Online en ja sv fr zh_Hans

• PDF docs: en ja, sv, zh_Hans, fr

• Cheat Sheets:

  • postgis: en ja sv fr zh_Hans
  • postgis_raster: en ja sv fr zh_Hans
  • postgis_topology: en ja sv fr zh_Hans
  • postgis_sfcgal: en ja sv fr zh_Hans
  • address standardizer, postgis_tiger_geocoder: en ja sv fr zh_Hans

This release includes bug fixes since PostGIS 3.5.3 and new features.

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)

• #5799, make ST_TileEnvelope clips envelopes to tile plane extent (Paul Ramsey)
• #5829, remove constraint checking from geometry_columns view (Paul Ramsey)
• #3373, GT-255, [topology] Support for upgrading domains (Ayo Adesugba, U.S. Census Bureau)
• GT-252, ST_NumGeometries/ST_GeometryN treat TIN and PolyhedralSurface as unitary geometries, use ST_NumPatches/ST_PatchN for patch access (Loïc Bartoletti)
• #3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
• #5359, #5897, GT-260 [tiger_geocoder] Use @extschema:extension@ for PG >= 16 to schema qualify dependent extensions, switch to use typmod for tiger tables (Regina Obe)

• #3110, GT-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 Drop st_approxquantile(raster, double precision), wasn’t usable as it triggered is not unique error when used (Regina Obe)

• GH-803, [sfcgal] ADD CG_Simplify function (Loïc Bartoletti)
• GH-805, [sfcgal] Add M support for SFCGAL >= 1.5.0 (Loïc Bartoletti)
• GH-801, [sfcgal] ADD CG_3DAlphaWrapping function (Jean Felder)
• #5894, [topology] TotalTopologySize (Sandro Santilli)
• #5890, [topology] ValidateTopologyPrecision, MakeTopologyPrecise (Sandro Santilli)
• #5861, [topology] Add –drop-topology switch to pgtopo_import (Sandro Santilli)
• #1247, [raster] ST_AsRasterAgg (Sandro Santilli)
• #5784, GT-223 Export circ_tree_distance_tree_internal for mobilitydb use (Maxime Schoemans)
• GT-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, 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, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
• [raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
• #5963, [raster] add ST_IntersectionFractions - Requires GEOS 3.14 (Paul Ramsey)
• #5971, Option to build –without-tiger (Regina Obe)

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.

SELECT postgis_extensions_upgrade();

For PostGIS 2.5 and below do:

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 or mailing list with details

View all tickets for 3.6.0 milestone.