If you are upgrading from an existing PostGIS install, make sure after installing PostGIS binaries to do.
ALTER EXTENSION postgis UPDATE;
— if you have additional postgishy extensions below upgrade them too
ALTER EXTENSION postgis_sfcgal UPDATE; ALTER EXTENSION postgis_topology UPDATE; ALTER EXTENSION postgis_tiger_geocoder UPDATE; ALTER EXTENSION pgrouting UPDATE;
In order to have Map Box Vector Tiles support enabled, you’ll need to compile with protobuf support
and pkg-config to verify the correct minimum version of protobuf-c see protobuf
function will not be enabled if PostGIS is compiled with lower than GEOS 3.7.0.
GEOS 3.7.0 is not released yet but is expected sometime next month.
Please report bugs that you find in this release.
Most aggregates now marked as parallel safe, which means most aggs have to be dropped / recreated. If you have views that utilize PostGIS aggs, you’ll need to drop before upgrade and recreate after upgrade
B-Tree index operators < = > changed to provide better spatial locality on sorting and have expected behavior on GROUP BY. It now works on exact geometry instead of bounding box. If you have btree index for geometry or geography, you need to REINDEX it, or review if it was created by accident and needs to be replaced with GiST index. If your code relies on old left-to-right box compare ordering, update it to use << >> operators.
_ST_DumpPoints removed, was no longer needed after PostGIS 2.1.0
when ST_DumpPoints got reimplemented in C
View all closed tickets for 2.4.0.
The PostGIS Team is pleased to release the release of PostGIS 3.1.1!
This release is a bug fix release, addressing issues found in the previous 3.1 release.
The PostGIS Team is pleased to release the release of PostGIS 3.1.0!
This version exposes the new features of GEOS 3.9 as well as numerous core performance enhancements for spatial joins, large object access, text format output and more.
The k-means clustering code has been enhanced to support weighting and higher dimensional clusters.
Geometry generators to create hexagonal and square tilings have been added, for simpler in-the-database summarization queries.
Finally, PostGIS exposes the latest enhancements in the GEOS geometry library 3.9 version. The new overlay engine (aka “OverlayNG”) provides more robust handling of difficult input geometries, using a set of new noding strategies to process geometry. For the end user, this should mean no more “topology exceptions” when using the union, difference, intersection or symmetric difference functions. PostGIS also exposes the new fixed precision overlay capability via an additional grid-size parameter on ST_Intersection and the other overlay functions.
The PostGIS Team is pleased to release the release candidate of the upcoming PostGIS 3.1.0 release. This version is exposes some of the new performance and feature enhancements in GEOS 3.9 as well as numerous speed enhancements not requiring newer GEOS.
Best served with: