<div><div dir="auto">Congrats! When is PostgreSQL 11 expected?</div></div><div><br><div class="gmail_quote"><div dir="ltr">On Sun, Sep 23, 2018 at 3:27 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The PostGIS development team is pleased to release PostGIS 2.5.0.<br>
<br>
Blog: <a href="http://postgis.net/2018/09/23/postgis-2.5.0/" rel="noreferrer" target="_blank">http://postgis.net/2018/09/23/postgis-2.5.0/</a><br>
<br>
<br>
Although this release will work for PostgreSQL 9.4 and above, <br>
to take full advantage of<br>
what PostGIS 2.5 offers, you should be running PostgreSQL 11beta4+ and GEOS<br>
3.7.0.<br>
<br>
Best served with PostgreSQL 11beta4+ and pgRouting 2.6.1<br>
<br>
WARNING: If compiling with PostgreSQL+JIT, LLVM >= 6 is required<br>
Supported PostgreSQL versions for this release are:<br>
PostgreSQL 9.4 - PostgreSQL 12 (in development)<br>
GEOS >= 3.5<br>
<br>
Source: <a href="https://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/source/postgis-2.5.0.tar.gz</a><br>
<br>
Documentation PDF: English:<br>
<a href="https://download.osgeo.org/postgis/docs/postgis-2.5.0.pdf" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/postgis-2.5.0.pdf</a><br>
<br>
German:<br>
<a href="https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2.5.0-de.pdf" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/https://postgis.net/stuff/postgis-2.<br>
5.0-de.pdf</a><br>
<br>
Html Documentation:<br>
<a href="https://download.osgeo.org/postgis/docs/doc-html-2.5.0.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/doc-html-2.5.0.tar.gz</a><br>
<br>
<br>
pgsql help files for non-english languages: <br>
German:<br>
<a href="https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/pgsql-help-2.5-de.tar.gz</a><br>
<br>
Japanese:<br>
<a href="https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/pgsql-help-2.5-ja.tar.gz</a><br>
<br>
Korean:<br>
<a href="https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/pgsql-help-2.5-kr.tar.gz</a><br>
<br>
Portuguese:<br>
<a href="https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/pgsql-help-2.5-br.tar.gz</a> <br>
<br>
Spanish:<br>
<a href="https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz" rel="noreferrer" target="_blank">https://download.osgeo.org/postgis/docs/pgsql-help-2.5-es.tar.gz</a><br>
<br>
<br>
Change Log: <a href="https://svn.osgeo.org/postgis/tags/2.5.0/ChangeLog" rel="noreferrer" target="_blank">https://svn.osgeo.org/postgis/tags/2.5.0/ChangeLog</a><br>
<br>
<br>
**New Features**<br>
* 1847, spgist 2d and 3d support for PG 11+<br>
(Esteban Zimányi and Arthur Lesuisse from Université Libre de Bruxelles<br>
(ULB),<br>
Darafei Praliaskouski)<br>
* 4056, ST_FilterByM (Nicklas Avén)<br>
* 4050, ST_ChaikinSmoothing (Nicklas Avén)<br>
* 3989, ST_Buffer single sided option (Stephen Knox)<br>
* 3876, ST_Angle function (Rémi Cura)<br>
* 3564, ST_LineInterpolatePoints (Dan Baston)<br>
* 3896, PostGIS_Extensions_Upgrade() (Regina Obe)<br>
* 3913, Upgrade when creating extension from unpackaged (Sandro Santilli)<br>
* 2256, _postgis_index_extent() for extent from index (Paul Ramsey)<br>
* 3176, Add ST_OrientedEnvelope (Dan Baston)<br>
* 4029, Add ST_QuantizeCoordinates (Dan Baston)<br>
* 4063, Optional false origin point for ST_Scale (Paul Ramsey)<br>
* 4082, Add ST_BandFileSize and ST_BandFileTimestamp,<br>
extend ST_BandMetadata (Even Rouault)<br>
* 2597, Add ST_Grayscale (Bborie Park)<br>
* 4007, Add ST_SetBandPath (Bborie Park)<br>
* 4008, Add ST_SetBandIndex (Bborie Park)<br>
<br>
**Breaking Changes**<br>
* 4054, ST_SimplifyVW changed from > tolerance to >= tolerance<br>
* 3885, version number removed from address_standardize lib file<br>
(Regina Obe)<br>
* 3893, raster support functions can only be loaded in the same schema<br>
with core PostGIS functions. (Sandro Santilli)<br>
* 4035, remove dummy pgis_abs type from aggregate/collect routines.<br>
(Paul Ramsey)<br>
* 4069, drop support for GEOS < 3.5 and PostgreSQL < 9.4 (Regina Obe)<br>
* 4082, ST_BandMetaData extended to include filesize, timestamp (Even<br>
Rouault)<br>
<br>
**Enhancements and Fixes**<br>
- Upgrade scripts from multiple old versions are now all symlinks<br>
to a single upgrade script (Sandro Santilli)<br>
* 3944, Update to EPSG register v9.2 (Even Rouault)<br>
* 3927, Parallel implementation of ST_AsMVT<br>
* 3925, Simplify geometry using map grid cell size before generating MVT<br>
* 3899, BTree sort order is now defined on collections of EMPTY and<br>
same-prefix geometries (Darafei Praliaskouski)<br>
* 3864, Performance improvement for sorting POINT geometries<br>
(Darafei Praliaskouski)<br>
* 3900, GCC warnings fixed, make -j is now working (Darafei Praliaskouski)<br>
- TopoGeo_addLinestring robustness improvements (Sandro Santilli)<br>
#1855, #1946, #3718, #3838<br>
* 3234, Do not accept EMPTY points as topology nodes (Sandro Santilli)<br>
* 1014, Hashable geometry, allowing direct use in CTE signatures (Paul<br>
Ramsey)<br>
* 3097, Really allow MULTILINESTRING blades in ST_Split() (Paul Ramsey)<br>
* 3942, geojson: Do not include private header for json-c >= 0.13 (Björn<br>
Esser)<br>
* 3954, ST_GeometricMedian now supports point weights (Darafei<br>
Praliaskouski)<br>
* 3965, #3971, #3977, #4071 ST_ClusterKMeans rewritten: better<br>
initialization,<br>
faster convergence, K=2 even faster (Darafei Praliaskouski)<br>
* 3982, ST_AsEncodedPolyline supports LINESTRING EMPTY and MULTIPOINT EMPTY<br>
(Darafei Praliaskouski)<br>
* 3986, ST_AsText now has second argument to limit decimal digits<br>
(Marc Ducobu, Darafei Praliaskouski)<br>
* 4020, Casting from box3d to geometry now returns correctly connected<br>
PolyhedralSurface (Matthias Bay)<br>
* 2508, ST_OffsetCurve now works with collections (Darafei Praliaskouski)<br>
* 4006, ST_GeomFromGeoJSON support for json and jsonb as input<br>
(Paul Ramsey, Regina Obe)<br>
* 4038, ST_Subdivide now selects pivot for geometry split that reuses input<br>
vertices. (Darafei Praliaskouski)<br>
* 4025, #4032 Fixed precision issue in ST_ClosestPointOfApproach,<br>
ST_DistanceCPA, and ST_CPAWithin (Paul Ramsey, Darafei<br>
Praliaskouski)<br>
* 4076, Reduce use of GEOS in topology implementation (Björn Harrtell)<br>
* 4080, Add external raster band index to ST_BandMetaData<br>
- Add Raster Tips section to Documentation for information about<br>
Raster behavior (e.g. Out-DB performance, maximum open files)<br>
* 4084: Fixed wrong code-comment regarding front/back of BOX3D (Matthias<br>
Bay)<br>
* 4060, #4094, PostgreSQL JIT support (Raúl Marín, Laurenz Albe)<br>
* 3960, ST_Centroid now uses lwgeom_centroid (Darafei Praliaskouski)<br>
* 4027, Remove duplicated code in lwgeom_geos (Darafei Praliaskouski,<br>
Daniel Baston)<br>
* 4115, Fix a bug that created MVTs with incorrect property values under<br>
parallel plans (Raúl Marín).<br>
* 4120, ST_AsMVTGeom: Clip using tile coordinates (Raúl Marín).<br>
* 4132, ST_Intersection on Raster now works without throwing<br>
TopologyException<br>
(Vinícius A.B. Schmidt, Darafei Praliaskouski)<br>
* 4177, #4180 Support for PostgreSQL 12 dev branch (Laurenz Albe, Raúl<br>
Marín)<br>
* 4156, ST_ChaikinSmoothing: also smooth start/end point of<br>
polygon by default (Darafei Praliaskouski)<br>
<br>
<br>
Thanks,<br>
PostGIS Development Team<br>
<br>
_______________________________________________<br>
Discuss mailing list<br>
<a href="mailto:Discuss@lists.osgeo.org" target="_blank">Discuss@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/discuss" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/discuss</a></blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>--</div><div>Jody Garnett</div></div></div></div></div>