PostGIS 3.4.0beta1

Jul 14, 2023 release 3.4

The PostGIS Team is pleased to release PostGIS 3.4.0beta1! Best Served with PostgreSQL 16 Beta2 and GEOS 3.12.0.

This version requires PostgreSQL 12 or higher, GEOS 3.6 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. To take advantage of all SFCGAL features, SFCGAL 1.4.1+ is needed.

3.4.0beta1

This release is a beta of a major release, it includes bug fixes since PostGIS 3.3.3 and new features.

Many thanks to our translation teams, in particular:

Teramoto Ikuhiro (Japanese Team) Vincent Bre (French Team)

New features

#5055, complete manual internationalization (Sandro Santilli)
#5052, target version support in postgis_extensions_upgrade (Sandro Santilli)
#5306, expose version of GEOS at compile time (Sandro Santilli)
New install-extension-upgrades command in postgis script (Sandro Santilli)
#5257, #5261, #5277, Support changes for PostgreSQL 16 (Regina Obe)
#5006, GH705, ST_Transform: Support PROJ pipelines (Robert Coup, Koordinates)
#5283, [postgis_topology] RenameTopology (Sandro Santilli)
#5286, [postgis_topology] RenameTopoGeometryColumn (Sandro Santilli)
GH703, [postgis_raster] Add min/max resampling as options (Christian Schroeder)
#5336, [postgis_topology] topogeometry cast to topoelement support (Regina Obe)
Allow singleton geometry to be inserted into Geometry(Multi*) columns (Paul Ramsey)
GH721, New window-based ST_ClusterWithinWin and ST_ClusterIntersectingWin (Paul Ramsey)
#5397, [address_standardizer] debug_standardize_address function (Regina Obe)
#5373, ST_LargestEmptyCircle, exposes extra semantics on circle finding Requires GEOS 3.9+ (Martin Davis)
#5267, ST_Project signature for geometry, and two-point signature (Paul Ramsey)
#5267, ST_LineExtend for extending linestrings (Paul Ramsey)

Enhancements

#5194, do not update system catalogs from postgis_extensions_upgrade (Sandro Santilli)
#5092, reduce number of upgrade paths installed on system (Sandro Santilli)
#635, honour –bindir (and –prefix) configure switch for executables (Sandro Santilli)
Honour –mandir (and –prefix) configure switch for man pages install path (Sandro Santilli)
Honour –htmldir (and –docdir and –prefix) configure switch for html pages install path (Sandro Santilli)
[postgis_topology] Speed up check of topology faces without edges (Sandro Santilli)
[postgis_topology] Speed up coincident nodes check in topology validation (Sandro Santilli)
GH718, ST_QuantizeCoordinates(): speed-up implementation (Even Rouault)
Repair spatial planner stats to use computed selectivity for contains/within queries (Paul Ramsey)
GH734, Additional metadata on Proj installation in postgis_proj_version (Paul Ramsey)
#5177, allow building tools without PostgreSQL server headers (Sandro Santilli)
ST_Project signature for geometry, and two-point signature (Paul Ramsey)
#4913, ST_AsSVG support for curve types CircularString, CompoundCurve, MultiCurve, and MultiSurface (Regina Obe)
#5266, ST_ClosestPoint, ST_ShortestLine support for geography type (MobilityDB Esteban Zimanyi, Paul Ramsey)

Breaking Changes

#5229, Drop support for Proj < 6.1 and PG 11 (Regina Obe)
#5306, GH734, postgis_full_version() and postgis_proj_version() now output more information about proj network configuration and data paths. GEOS compile-time version also shown if different from run-time (Paul Ramsey, Sandro Santilli)

Upgrading

After installing the binaries or after running pg_upgrade:

For PostGIS 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.4.0beta1 milestone.