Context Navigation

Changes between Version 211 and Version 212 of UsersWikiPostgreSQLPostGIS

Timestamp:: Nov 8, 2022, 1:17:35 PM (18 months ago)
Author:: robe
Comment:: —

Legend:

: Unmodified
: Added
: Removed
: Modified

UsersWikiPostgreSQLPostGIS

-              v211
+              v212
  * json-c 0.16 [[Image(https://repology.org/badge/latest-versions/json-c.svg)]] https://github.com/json-c/json-c
+Obsolete versions can be found at - [[PostGISObsoleteVersionsMatrix]][[br]]
 = PostGIS Support Matrix =
-[[EOL'd versions for historical]]
 '''Versions of PostgreSQL supported by which versions of PostGIS'''
+||'''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'''
+||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
+||'''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''
+||'''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''
+||'''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''
+||'''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''
+||'''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''
+||'''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''
+||'''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
+||'''[[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
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''[[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''
+||'''PostgreSQL version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3''' ||'''PostGIS 3.4'''
+||PostGIS release date|| 2018/09/23|| 2019/10/20|| 2020/12/18|| 2021/12/18|| 2022/08/27|| 20XX/XX/XX
+||'''16'''||No||No||No||''No''||''Yes*''||''Yes''
+||'''15'''||No||No||No||''Yes*''||''Yes''||''Yes''
+||'''14'''||No||No||Yes||''Yes''||''Yes''||''Yes''
+||'''13'''||No||Yes||Yes||''Yes''||''Yes''||''Yes''
+||'''12'''||Yes||Yes||Yes||''Yes''||''Yes''||''Yes''
+||'''11'''||Yes||Yes||Yes||''Yes''||''Yes''||''No''
 Versions 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.
 …
 Yes ^(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.
 Yes * - currently works but may not work at release time.
+Yes * - currently works but may not work at release time or fails some regression tests
 Blank slots means it doesn't work.
+||'''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'''
+||'''3.11'''||No||No||No||No||No||No||No||No||No||No||Yes||Yes*||Yes
+||'''3.10'''||No||No||No||No||No||No||No||No||No||Yes||Yes||Yes||Yes
+||'''3.9'''||No||No||No||No||No||No||Yes ^(1)^||Yes ^(1)^||Yes ^(1)^||Yes||Yes||Yes||Yes
+||'''3.8'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
+||'''3.7'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes
+||'''3.6 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes||Yes*
+||'''3.5 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes (recommended)||Yes||Yes||Yes||No||No
+||'''3.4 EOL'''||Yes||Yes||Yes (preferred 3.4.2+)||Yes (3.4.2+)||Yes||Yes*||Yes*||Yes*
+||'''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
+||'''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
+||'''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
+||'''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
+||'''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
+||'''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
+||'''Geos Version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''||'''PostGIS 3.4'''
+||'''3.12'''||Yes^(1)^||Yes^(1)^||Yes^(1)^||Yes||Yes||Yes
+||'''3.11'''||Yes^(1)^||Yes^(1)^||Yes^(1)^||Yes||Yes^(1)^||Yes
+||'''3.10'''||Yes^(1)^||Yes^(1)^||Yes||Yes||Yes||Yes
+||'''3.9'''||Yes ^(1)^||Yes ^(1)^||Yes||Yes||Yes||Yes
+||'''3.8'''||Yes||Yes||Yes||Yes||Yes||Yes
+||'''3.7'''||Yes||Yes||Yes||Yes||Yes||Yes
+||'''3.6 EOL'''||Yes||Yes||Yes||Yes||Yes||Yes*
 '''Versions of Proj support for PostGIS'''
 …
 If a cell is not filled in after, means support stopped for it.
+||'''PROJ Version'''||'''PostGIS 2.4'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''
+||'''8.1-8.2'''||No||No||Yes||Yes||Yes||Yes
+||'''7.0-7.2'''||No||Yes (1)||Yes||Yes||Yes||Yes
+||'''6.0'''||No||Yes||Yes||Yes||Yes||Yes
+||'''6.1-6.3'''||No||Yes||Yes||Yes||Yes||Yes
+||'''5.0-5.2'''||Yes||Yes||Yes||Yes||Yes
+||'''4.9'''||Yes||Yes||Yes||Yes||Yes ^(2)^
+||'''4.8'''||Yes||Yes||Yes ^(2)^
+||'''PROJ Version'''||'''PostGIS 2.5'''||'''PostGIS 3.0'''||'''PostGIS 3.1'''||'''PostGIS 3.2'''||'''PostGIS 3.3'''||'''PostGIS 3.4'''
+||'''8.1-8.2'''||No||Yes||Yes||Yes||Yes||Yes
+||'''7.0-7.2'''||Yes (1)||Yes||Yes||Yes||Yes||Yes
+||'''6.1-6.3'''||Yes||Yes||Yes||Yes||Yes||Yes
+||'''6.0'''||No||Yes||Yes||Yes||Yes||No
+||'''5.0-5.2'''||Yes||Yes||Yes||Yes||Yes||No