The PostGIS development team is pleased to announce the release of PostGIS 2.3.0.
This is the first version to utilize the parallel support functionality introduced in PostgreSQL 9.6. As such, if you are using PostgreSQL 9.6, we strongly encourage you to use this version.
Parallel support will make many queries using PostGIS relationship operators and functions faster.
In order to take advantage of parallel query support, make sure to set
max_parallel_workers_per_gather to something greater than 0
as noted in
max_parallel_workers_per_gather PostgreSQL runtime configs
Best served with [PostgreSQL 9.6+] which is due out this week and pgRouting 2.3.0 which also just got released.
Packages from maintainers will be out in the coming days and weeks.
If you are a Mac user using newer XCode 8, you might run into some compilation issues as a result of recent changes in XCode. Refer to https://trac.osgeo.org/postgis/ticket/3643 for a patch you can use.
Please report bugs that you find in this release.
Important / Breaking Changes / Bug Fixes
3466, Casting from box3d to geometry now returns a 3D geometry (Julien Rouhaud of Dalibo)
3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to wrong liblwgeom.h (Greg Troxel)
3396, ST_EstimatedExtent, now throws WARNING instead of ERROR (Regina Obe)
New Features and Performance Enhancements
Add support for custom TOC in postgis_restore.pl (Christoph Moench-Tegeder)
3613, Segmentize geography using equal length segments (Hugo Mercier of Oslandia)
75, Enhancement to PIP short circuit (Dan Baston)
View all closed tickets for 2.3.0.
The PostGIS development team is pleased to provide bug fix release 2.3.6 and 2.4.3 for the 2.3 and 2.4 stable branches.
Key fixes in these releases are Brin upgrade, ST_Transform schema qualification to fix issues with restore, foreign table, and materialized view use, ClusterKMeans and encoded polyline fixes.
View all closed tickets for 2.4.3 and 2.3.6.
After installing the binaries or after running pg_upgrade, make sure to do:
ALTER EXTENSION postgis UPDATE;
— if you use the other extensions packaged with postgis — make sure to upgrade those as well
ALTER EXTENSION postgis_sfcgal UPDATE; ALTER EXTENSION postgis_topology UPDATE; ALTER EXTENSION postgis_tiger_geocoder UPDATE;
If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version packaged with these releases.
The PostGIS development team has uploaded bug fix releases for the 2.3 and 2.4 stable branches.
The PostGIS development team has uploaded bug fix releases for the 2.2, 2.3 and 2.4 stable branches.