Changes between Version 186 and Version 187 of UsersWikiPostgreSQLPostGIS


Ignore:
Timestamp:
09/03/21 19:00:16 (3 years ago)
Author:
robe
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiPostgreSQLPostGIS

    v186 v187  
    1616
    1717'''Versions of PostgreSQL supported by which versions of PostGIS'''
    18 ||'''PostgreSQL version'''||'''PostGIS 1.3 EOL'''||'''PostGIS 1.4 EOL'''||'''PostGIS 1.5 EOL'''||'''PostGIS 2.0 EOL'''||'''PostGIS 2.1 EOL''' ||'''PostGIS 2.2 EOL ''' ||'''PostGIS 2.3 EOL '''||'''PostGIS 2.4'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1||'''PostGIS 3.2'''
     18||'''PostgreSQL version'''||'''PostGIS 1.3 EOL'''||'''PostGIS 1.4 EOL'''||'''PostGIS 1.5 EOL'''||'''PostGIS 2.0 EOL'''||'''PostGIS 2.1 EOL''' ||'''PostGIS 2.2 EOL ''' ||'''PostGIS 2.3 EOL '''||'''PostGIS 2.4'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''
    1919||PostGIS release date|| 2007/08/09|| 2009/07/24|| 2010/02/04|| 2012/04/03|| 2013/08/17|| 2015/10/07|| 2016/09/26|| 2017/09/30|| 2018/09/23|| 2019/10/20|| 2020/12/18|| 2021/XX/XX
    20 ||'''14'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||No||'''No'''||'''Yes'''||''Yes''
    21 ||'''13'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||No||'''Yes'''||'''Yes'''||''Yes''
    22 ||'''12'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||'''Yes'''||'''Yes'''||'''Yes'''||''Yes''
    23 ||'''11'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||Yes*||'''Yes'''||'''Yes'''||'''Yes'''||''Yes''
    24 ||'''10'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes (not recommended))]]||'''Yes'''||'''Yes'''||'''Yes'''||'''Yes'''||''Yes''
    25 ||'''9.6'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes (not recommended))]]||[[span(style=color: grey, Yes)]]||'''Yes'''||'''Yes'''||'''Yes'''||'''Yes'''||''Yes''
    26 ||'''9.5'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||'''Yes'''||'''Yes'''||'''Yes'''||No||''No''
     20||'''14'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||No||No'||Yes||''Yes''
     21||'''13'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||No||Yes||Yes||''Yes''
     22||'''12'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No||Yes||Yes||Yes||''Yes''
     23||'''11'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||Yes*||Yes||Yes||Yes||''Yes''
     24||'''10'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes (not recommended))]]||Yes||Yes||Yes||Yes||''Yes''
     25||'''9.6'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes (not recommended))]]||[[span(style=color: grey, Yes)]]||Yes||Yes||Yes||Yes||''Yes''
     26||'''9.5'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||Yes||Yes||Yes||No||''No''
    2727||'''[[span(style=color: grey, 9.4 EOL)]]'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
    2828||'''[[span(style=color: grey, 9.3 EOL)]]'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
    … …  
    5858The none means that you can get that version to work without GEOS, though its not recommended since a lot of functions will not be installed. 
    5959
    60 For the not recommended, this means that while you can get PostGIS to work with those versions, you'll be missing out on some PostGIS functions such as ST_Covers, ST_CoversBy and for PostGIS 1.5 the ST_HausdorffDistance and enhancements to ST_Buffer (both speed and functionality).
     60For the not recommended, this means that while you can get PostGIS to work with those versions, you'll be missing out on some PostGIS functions.
    6161
    62 GEOS 3.1 brought cascade union.
    6362
    64 GEOS 3.2 brought faster buffering and buffering enhancements, plus numerous enhancements with dealing with tolerance issues when unioning.
    65 
    66 GEOS 3.3 brought ST_ValidReason, ST_MakeValid etc (in the PostGIS 2.0 releases), so these functions will be disabled in PostGIS 2.0 if you are not running GEOS 3.3. GEOS 3.3. also brought stability fixes for union/buffer not back-ported to 3.2.  For PostGIS 1.5, although 3.3 does not add any additional functions, it does fix some crashers involving buffering and unioning not present in other minor releases, so suggested to use that if you can.
    67 
    68 GEOS 3.4 introduced interruptibility features that allow you to cancel a query while in a GEOS loops.  Prior versions of PostGIS/GEOS a query could run (even with statement timeout) until you ran out of memory. This new feature requires both PostGIS 2.1+ and GEOS 3.4+.  3.4 also brought [http://postgis.net/docs/manual-2.1/ST_DelaunayTriangles.html ST_DelaunayTriangles] so you won't get that in 2.1 if you don't compile for 3.4+.
    69 
    70 GEOS 3.5 brought some enhancements needed new features in PostGIS 2.2 [http://postgis.net/docs/manual-2.2/ST_Subdivide.html ST_Subdivide] and [http://postgis.net/docs/manual-2.2/ST_ClipByBox2D.html ST_ClipByBox2D].
    71 GEOS 3.5 also brought ST_Voronoi so if compiled with lower than 3.5, the ST_Voronoi introduced in PostGIS 2.3 won't be available [http://postgis.net/docs/manual-2.3/ST_VoronoiLines.html ST_VoronoiLines and ST_VoronoiPolygons].
    72 
    73 GEOS 3.6.0 came out after 2.3.0 release, so most 2.3 distros will not have enabled - [http://postgis.net/docs/manual-2.3/ST_MinimumClearance.html ST_MinimumClearance*] that require 3.6, but may in 2.3.1
    74 
    75 ||'''Geos Version'''||'''PostGIS 1.3 EOL'''||'''PostGIS 1.4 EOL'''||'''PostGIS 1.5 EOL'''||'''PostGIS 2.0 EOL'''||'''PostGIS 2.1 EOL'''||'''PostGIS 2.2 EOL'''||'''PostGIS 2.3'''||'''PostGIS 2.4'''||'''PostGIS 2.5'''
    76 ||'''3.8*'''||Yes||Yes||Yes||Yes||Yes||'''Yes'''||'''Yes'''||'''Yes'''||'''Yes'''
    77 ||'''3.7'''||Yes||Yes||Yes||Yes||Yes||'''Yes'''||'''Yes'''||'''Yes'''||'''Yes'''
    78 ||'''3.6'''||Yes||Yes||Yes||Yes||Yes||'''Yes'''||'''Yes''' (recommended)||Yes*||Yes*
    79 ||'''3.5'''||Yes||Yes||Yes||Yes||Yes||'''Yes''' (recommended)||Yes*||Yes*||Yes*
     63||'''Geos Version'''||'''PostGIS 1.3 EOL'''||'''PostGIS 1.4 EOL'''||'''PostGIS 1.5 EOL'''||'''PostGIS 2.0 EOL'''||'''PostGIS 2.1 EOL'''||'''PostGIS 2.2 EOL'''||'''PostGIS 2.3'''||'''PostGIS 2.4'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''
     64||'''3.10'''||No||No||No||No||No||No||No||No||No||Yes*||Yes||Yes
     65||'''3.9'''||No||No||No||No||No||No||No||No||No||Yes||Yes||Yes
     66||'''3.8'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
     67||'''3.7'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
     68||'''3.6'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes (recommended)||Yes*||Yes*
     69||'''3.5'''||Yes||Yes||Yes||Yes||Yes||Yes (recommended)||Yes*||Yes*||Yes*
    8070||'''3.4'''||Yes||Yes||Yes (preferred 3.4.2+)||Yes (3.4.2+)||Yes||Yes*||Yes*||Yes*||No
    8171||'''3.3 EOL'''||Yes||Yes||Yes (preferred 3.3.3+)||Yes (3.3.9+)||Yes (not recommended)||Yes*||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No