PostGIS 2.5.0

  • 时间: 2018-09-24 05:02:25

The PostGIS development team is pleased to release PostGIS 2.5.0.

Although this release will work for PostgreSQL 9.4 and above, to take full advantage ofwhat PostGIS 2.5 offers, you should be running PostgreSQL 11beta4+ and GEOS 3.7.0which were released recently.

Best served with PostgreSQL 11 beta4and pgRouting 2.6.1.

WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is requiredSupported PostgreSQL versions for this release are:PostgreSQL 9.4 - PostgreSQL 12 (in development)GEOS >= 3.5


New Features* 1847, spgist 2d and 3d support for PG 11+ (Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles (ULB), Darafei Praliaskouski)* 4056, ST FilterByM (Nicklas Avén)* 4050, STChaikinSmoothing (Nicklas Avén)* 3989, ST Buffer single sided option (Stephen Knox)* 3876, STAngle function (Rémi Cura)* 3564, ST LineInterpolatePoints (Dan Baston)* 3896, PostGISExtensions Upgrade() (Regina Obe)* 3913, Upgrade when creating extension from unpackaged (Sandro Santilli)* 2256, _postgisindex extent() for extent from index (Paul Ramsey)* 3176, Add STOrientedEnvelope (Dan Baston)* 4029, Add ST QuantizeCoordinates (Dan Baston)* 4063, Optional false origin point for STScale (Paul Ramsey)* 4082, Add ST BandFileSize and STBandFileTimestamp, extend ST BandMetadata (Even Rouault)* 2597, Add STGrayscale (Bborie Park)* 4007, Add ST SetBandPath (Bborie Park)* 4008, Add STSetBandIndex (Bborie Park)

Breaking Changes* 4054, ST SimplifyVW changed from > tolerance to >= tolerance* 3885, version number removed from addressstandardize lib file (Regina Obe)* 3893, raster support functions can only be loaded in the same schema with core PostGIS functions. (Sandro Santilli)* 4035, remove dummy pgis abs type from aggregate/collect routines. (Paul Ramsey)* 4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)* 4082, STBandMetaData extended to include filesize, timestamp (Even Rouault)

Enhancements and Fixes- Upgrade scripts from multiple old versions are now all symlinks to a single upgrade script (Sandro Santilli)* 3944, Update to EPSG register v9.2 (Even Rouault)* 3927, Parallel implementation of ST AsMVT* 3925, Simplify geometry using map grid cell size before generating MVT* 3899, BTree sort order is now defined on collections of EMPTY and same-prefix geometries (Darafei Praliaskouski)* 3864, Performance improvement for sorting POINT geometries (Darafei Praliaskouski)* 3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski) - TopoGeoaddLinestring robustness improvements (Sandro Santilli) #1855, #1946, #3718, #3838* 3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)* 1014, Hashable geometry, allowing direct use in CTE signatures (Paul Ramsey)* 3097, Really allow MULTILINESTRING blades in ST Split() (Paul Ramsey)* 3942, geojson: Do not include private header for json-c >= 0.13 (Björn Esser)* 3954, STGeometricMedian now supports point weights (Darafei Praliaskouski)* 3965, #3971, #3977, #4071 ST ClusterKMeans rewritten: better initialization, faster convergence, K=2 even faster (Darafei Praliaskouski)* 3982, STAsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY (Darafei Praliaskouski)* 3986, ST AsText now has second argument to limit decimal digits (Marc Ducobu, Darafei Praliaskouski)* 4020, Casting from box3d to geometry now returns correctly connected PolyhedralSurface (Matthias Bay)* 2508, STOffsetCurve now works with collections (Darafei Praliaskouski)* 4006, ST GeomFromGeoJSON support for json and jsonb as input (Paul Ramsey, Regina Obe)* 4038, STSubdivide now selects pivot for geometry split that reuses input vertices. (Darafei Praliaskouski)* 4025, #4032 Fixed precision issue in ST ClosestPointOfApproach, STDistanceCPA, and ST CPAWithin (Paul Ramsey, Darafei Praliaskouski)* 4076, Reduce use of GEOS in topology implementation (Björn Harrtell)* 4080, Add external raster band index to STBandMetaData - Add Raster Tips section to Documentation for information about Raster behavior (e.g. Out-DB performance, maximum open files)* 4084: Fixed wrong code-comment regarding front/back of BOX3D (Matthias Bay)* 4060, #4094, PostgreSQL JIT support (Raúl Marín, Laurenz Albe)* 3960, ST Centroid now uses lwgeomcentroid (Darafei Praliaskouski)* 4027, Remove duplicated code in lwgeom geos (Darafei Praliaskouski, Daniel Baston)* 4115, Fix a bug that created MVTs with incorrect property values under parallel plans (Raúl Marín).* 4120, STAsMVTGeom: Clip using tile coordinates (Raúl Marín).* 4132, ST Intersection on Raster now works without throwing TopologyException (Vinícius A.B. Schmidt, Darafei Praliaskouski)* 4177, #4180 Support for PostgreSQL 12 dev branch (Laurenz Albe, Raúl Marín)* 4156, STChaikinSmoothing: also smooth start/end point of polygon by default (Darafei Praliaskouski)

View all closed tickets for 2.5.0.

After installing the binaries or after running pg_upgrade, make sure to do:


— 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.