PostGIS

Spatial and Geographic objects for PostgreSQL

  • Home
  • Download
  • Documentation
  • Development
  • Support

PostGIS 2.4.0beta1 Released

Author: Regina Obe  2017/09/02  in news ( release, 2.4, 2.4.0beta1 )

The PostGIS development team is pleased to announce the release of PostGIS 2.4.0beta1. PostGIS 2.4.0 will be the first version to support PostgreSQL 10. Best served with PostgreSQL 10beta4 and pgRouting 2.5.0beta See the full list of changes in the news file.

We encourage everyone to test and in particular package maintainers to insure no surprises at final release time.

IMPORTANT NOTES

From this point forward until release of PostGIS 2.4.0, no new functions will be added.
Only bug fixes will be addressed in future 2.4.0 betas and rcs.

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 for details. ST_FrechetDistance function will not be enabled if PostGIS is compiled with lower than GEOS 3.7.0. GEOS 3.7.0 will be released around the same time as PostGIS 2.4.0 and will have a beta release in a week.

  • Source Download
  • html doc download (this version includes Japanese translation postgis-ja.html)
  • pdf doc download
  • epub doc download
  • ChangeLog

Please report bugs that you find in this release.

New Features

  • 3822, Have postgisfullversion() also show and check version of PostgreSQL the scripts were built against (Sandro Santilli)
  • 2411, curves support in ST_Reverse (Sandro Santilli)
  • 2951, ST_Centroid for geography (Danny Götte)
  • 3788, Allow postgis_restore.pl to work on directory-style (-Fd) dumps (Roger Crew)
  • 3772, Direction agnostic ST_CurveToLine output (Sandro Santilli / KKGeo)
  • 2464, ST_CurveToLine with MaxError tolerance (Sandro Santilli / KKGeo)
  • 3599, Geobuf output support via ST_AsGeobuf (Björn Harrtell)
  • 3661, Mapbox vector tile output support via ST_AsMVT (Björn Harrtell / Carto)
  • 3689, Add orientation checking and forcing functions (Dan Baston)
  • 3753, Gist penalty speed improvements for 2d and nd points (Darafei Praliaskouski)
  • 3677, ST_FrechetDistance (Shinichi Sugiyama)
  • Most aggregates (raster and geometry), and all stable / immutable (raster and geometry) marked as parallel safe
  • 2249, ST_MakeEmptyCoverage for raster (David Zwarg, ainomieli)
  • 3709, Allow signed distance for ST_Project (Darafei Praliaskouski)
  • 524, Covers support for Polygon-on-polygon, line on line, point on line for geography (Danny Götte)

Enhancements

  • Support for PostgreSQL 10
  • 3747, Add zip4 and addressalphanumeric as attributes to normaddy tiger_geocoder type.
  • 3748, addressstandardizer lookup tables update so pagcnormalize_address better standardizes abbreviations
  • 3647, better handling of noding in ST_Node using GEOSNode (Wouter Geraedts)
  • 3684, Update to EPSG register v9 (Even Rouault)

Breaking Changes

  • Dropped support for PostgreSQL 9.2.
  • 3810, GEOS 3.4.0 or above minimum required to compile
  • 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

View all closed tickets for 2.4.0.

More Posts

PostGIS 3.1.1

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.

  • #4814, Crash passing collection with only empty components to ST_MakeValid
  • #4818, Make the VSICURL synthetic driver work as documented
  • #4825, Unstable results from ST_MakeValid
  • #4823, Avoid listing the same geometry in different collections

Read more...


PostGIS 3.1.0

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.

Performance is a key feature of this release, with improvements to spatial joins, text outputs, large object reads, vector tile output, and a host of smaller tweaks.

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.

Read more...


PostGIS 3.1.0rc1

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:

  • PostgreSQL 13.1
  • GEOS 3.9
  • pgRouting 3.1.1

Read more...


Site Map

  • Home
  • Install
  • Documentation
  • Development
  • Planet PostGIS
  • Support

PostGIS Project Steering Committee (PSC)

  • Paul Ramsey (Chair)
  • Sandro Santilli
  • Regina Obe
  • Bborie Park
  • Darafei Praliaskouski
  • Raúl Marín Rodríguez