Changes between Version 211 and Version 212 of UsersWikiPostgreSQLPostGIS


Ignore:
Timestamp:
11/08/22 13:17:35 (2 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiPostgreSQLPostGIS

    v211 v212  
    1212 * json-c 0.16 [[Image(https://repology.org/badge/latest-versions/json-c.svg)]] https://github.com/json-c/json-c
    1313
     14Obsolete versions can be found at - [[PostGISObsoleteVersionsMatrix]][[br]]
     15
    1416= PostGIS Support Matrix =
    1517
    16 [[EOL'd versions for historical]]
    1718'''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 EOL'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3''' ||'''PostGIS 3.4'''
    19 ||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/12/18|| 2022/08/27|| 20XX/XX/XX
    20 ||'''16'''||[[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||No||''No''||''Yes*''||''Yes''
    21 ||'''15'''||[[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||No||''Yes*''||''Yes''||''Yes''
    22 ||'''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''||''Yes''||''Yes''
    23 ||'''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''||''Yes''||''Yes''
    24 ||'''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''||''Yes''||''Yes''
    25 ||'''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''||''Yes''||''No''
    26 ||'''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
    27 ||'''[[span(style=color: grey, 9.6 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, No)]]||[[span(style=color: grey, Yes (not recommended))]]||[[span(style=color: grey, Yes)]]||Yes||Yes||Yes||Yes||Yes
    28 ||'''[[span(style=color: grey, 9.5 EOL)]]'''||[[span(style=color: grey, Yes)]]||[[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''
    29 ||'''[[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''
    30 ||'''[[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''
    31 ||'''[[span(style=color: grey, 9.2 EOL)]]'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes (not recommended))]]||[[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)]]||[[span(style=color: grey, No)]]||''No''
    32 ||'''[[span(style=color: grey, 9.1 EOL)]]'''||[[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)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
    33 ||'''[[span(style=color: grey, 9.0 EOL)]]'''||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes (not recommended))]]||[[span(style=color: grey, Yes (not recommended))]]||[[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''
    34 ||'''[[span(style=color: grey, 8.4 EOL)]]'''||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes)]]||[[span(style=color: grey, Yes (not recommended))]]||[[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''
    35 ||'''[[span(style=color: grey, 8.3 EOL)]]'''||[[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)]]||[[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''
    36 ||'''[[span(style=color: grey, 8.2 EOL)]]'''||[[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)]]||[[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''
    37 ||'''[[span(style=color: grey, 8.1 EOL)]]'''||[[span(style=color: grey, Yes)]]||[[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)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
    38 ||'''[[span(style=color: grey, 8.0 EOL)]]'''||[[span(style=color: grey, Yes (not windows))]]||[[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)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
    39 ||'''[[span(style=color: grey, 7.2-7.4 EOL)]]'''||[[span(style=color: grey, Yes (not windows))]]||[[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)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||''No''
     19||'''PostgreSQL version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3''' ||'''PostGIS 3.4'''
     20||PostGIS release date|| 2018/09/23|| 2019/10/20|| 2020/12/18|| 2021/12/18|| 2022/08/27|| 20XX/XX/XX
     21||'''16'''||No||No||No||''No''||''Yes*''||''Yes''
     22||'''15'''||No||No||No||''Yes*''||''Yes''||''Yes''
     23||'''14'''||No||No||Yes||''Yes''||''Yes''||''Yes''
     24||'''13'''||No||Yes||Yes||''Yes''||''Yes''||''Yes''
     25||'''12'''||Yes||Yes||Yes||''Yes''||''Yes''||''Yes''
     26||'''11'''||Yes||Yes||Yes||''Yes''||''Yes''||''No''
     27
    4028
    4129Versions of PostGIS labeled 'EOL' will no longer receive any micro updates or security patches. If you are running these you should upgrade to the latest version you can.
     
    6351Yes ^(1)^ means we assume it works, but don't test it and haven't patched tests to regress cleanly.  Some regression tests may fail as newer version give slightly different answers from previous versions.
    6452
    65 Yes * - currently works but may not work at release time.
     53Yes * - currently works but may not work at release time or fails some regression tests
    6654Blank slots means it doesn't work.
    6755
    6856
    69 ||'''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'''||'''PostGIS 3.3'''
    70 ||'''3.11'''||No||No||No||No||No||No||No||No||No||No||Yes||Yes*||Yes
    71 ||'''3.10'''||No||No||No||No||No||No||No||No||No||Yes||Yes||Yes||Yes
    72 ||'''3.9'''||No||No||No||No||No||No||Yes ^(1)^||Yes ^(1)^||Yes ^(1)^||Yes||Yes||Yes||Yes
    73 ||'''3.8'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
    74 ||'''3.7'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
    75 ||'''3.6 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes*
    76 ||'''3.5 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes (recommended)||Yes||Yes||Yes||No||No
    77 ||'''3.4 EOL'''||Yes||Yes||Yes (preferred 3.4.2+)||Yes (3.4.2+)||Yes||Yes*||Yes*||Yes*
    78 ||'''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
    79 ||'''3.2 EOL'''||Yes||Yes||Yes||Yes (not recommended)||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||[[span(style=color: grey, No)]]||No
    80 ||'''3.1 EOL'''||Yes||Yes||Yes (not recommended) (requires 3.1.1+)||[[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
    81 ||'''3.0 EOL'''||Yes||Yes (not recommended)||[[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
    82 ||'''2.2 EOL'''||Yes (not recommended)||[[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
    83 ||'''None'''||Yes (not recommended)||[[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
     57||'''Geos Version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''||'''PostGIS 3.4'''
     58||'''3.12'''||Yes^(1)^||Yes^(1)^||Yes^(1)^||Yes||Yes||Yes
     59||'''3.11'''||Yes^(1)^||Yes^(1)^||Yes^(1)^||Yes||Yes^(1)^||Yes
     60||'''3.10'''||Yes^(1)^||Yes^(1)^||Yes||Yes||Yes||Yes
     61||'''3.9'''||Yes ^(1)^||Yes ^(1)^||Yes||Yes||Yes||Yes
     62||'''3.8'''||Yes||Yes||Yes||Yes||Yes||Yes
     63||'''3.7'''||Yes||Yes||Yes||Yes||Yes||Yes
     64||'''3.6 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes*
     65
    8466
    8567'''Versions of Proj support for PostGIS'''
     
    9173If a cell is not filled in after, means support stopped for it.
    9274
    93 ||'''PROJ Version'''||'''PostGIS 2.4'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''
    94 ||'''8.1-8.2'''||No||No||Yes||Yes||Yes||Yes
    95 ||'''7.0-7.2'''||No||Yes (1)||Yes||Yes||Yes||Yes
    96 ||'''6.0'''||No||Yes||Yes||Yes||Yes||Yes
    97 ||'''6.1-6.3'''||No||Yes||Yes||Yes||Yes||Yes
    98 ||'''5.0-5.2'''||Yes||Yes||Yes||Yes||Yes
    99 ||'''4.9'''||Yes||Yes||Yes||Yes||Yes ^(2)^
    100 ||'''4.8'''||Yes||Yes||Yes ^(2)^
     75||'''PROJ Version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''||'''PostGIS 3.4'''
     76||'''8.1-8.2'''||No||Yes||Yes||Yes||Yes||Yes
     77||'''7.0-7.2'''||Yes (1)||Yes||Yes||Yes||Yes||Yes
     78||'''6.1-6.3'''||Yes||Yes||Yes||Yes||Yes||Yes
     79||'''6.0'''||No||Yes||Yes||Yes||Yes||No
     80||'''5.0-5.2'''||Yes||Yes||Yes||Yes||Yes||No
    10181
    10282