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 PostGIS 3.2.0, the Olivier Courtin release.
This release would not be possible without the various developers listed in the credits as well as the companies that provided funding and developer time.
Companies that contributed significantly to this release are:
In March 2020 we lost a long time PostGIS developer and friend, Olivier Courtin. The PostGIS 3.2.0 release is named in his honor.
The PostGIS Team is pleased to release the first rc of the upcoming PostGIS 3.2.0 release.
Best served with PostgreSQL 14. This version of PostGIS can utilize the faster GiST building support API introduced in PostgreSQL 14. If compiled with recently released GEOS 3.10.1 you can take advantage of improvements in ST_MakeValid and numerous speed improvements. This release also includes many additional functions and improvements for
postgis_topology extensions and a new input/export format FlatGeobuf.