Current best

As of 03 February 10th, 2022 these versions are latest and give you best stable feature coverage.

• PostGIS 3.2.0
• PostgreSQL 14.1
• GEOS 3.10.1 ​https://github.com/libgeos/geos/blob/main/NEWS
• SFCGAL 1.3.9 ​https://gitlab.com/Oslandia/SFCGAL/-/releases
• GDAL 3.3.1 ​https://github.com/OSGeo/gdal/releases
• PROJ 8.1.0 ​https://github.com/OSGeo/PROJ/releases
• protobuf-c 1.4.0 ​https://github.com/protobuf-c/protobuf-c/releases
• json-c 0.15 ​https://github.com/json-c/json-c

PostGIS Support Matrix

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

PostGIS 2.5

PostGIS 3.0

PostGIS 3.1

PostGIS 3.2

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

14

No

No

No

No

No

No

No

No

No

No

Yes

Yes

13

No

No

No

No

No

No

No

No

No

Yes

Yes

Yes

12

No

No

No

No

No

No

No

No

Yes

Yes

Yes

Yes

11

No

No

No

No

No

No

No

Yes*

Yes

Yes

Yes

Yes

10

No

No

No

No

No

No

Yes (not recommended)

Yes

Yes

Yes

Yes

Yes

9.6

No

No

No

No

No

Yes (not recommended)

Yes

Yes

Yes

Yes

Yes

Yes

9.5

No

No

No

No

No

Yes

Yes

Yes

Yes

Yes

No

No

9.4 EOL

No

No

No

No

Yes

Yes

Yes

Yes

Yes

No

No

No

9.3 EOL

No

No

No

No

Yes

Yes

Yes

Yes

No

No

No

No

9.2 EOL

No

No

Yes (not recommended)

Yes

Yes

Yes

Yes

No

No

No

No

No

9.1 EOL

No

No

Yes

Yes

Yes

Yes

No

No

No

No

No

No

9.0 EOL

No

No

Yes

Yes (not recommended)

Yes (not recommended)

No

No

No

No

No

No

No

8.4 EOL

Yes

Yes

Yes

Yes (not recommended)

No

No

No

No

No

No

No

No

8.3 EOL

Yes

Yes

Yes

No

No

No

No

No

No

No

No

No

8.2 EOL

Yes

Yes

No

No

No

No

No

No

No

No

No

No

8.1 EOL

Yes

No

No

No

No

No

No

No

No

No

No

No

8.0 EOL

Yes (not windows)

No

No

No

No

No

No

No

No

No

No

No

7.2-7.4 EOL

Yes (not windows)

No

No

No

No

No

No

No

No

No

No

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.

The not recommended note means you can compile and install with that, but you'll be missing some functionality.

^* Means it currently does or doesn't but may change at release time.

If you are compiling PostGIS 2.0+ with anything less than 9.1, you will not get CREATE EXTENSION support and will also not get KNN gist distance for geometry.

As a general rule, the PostGIS Project Steering committee tries to maintain support of PostGIS for at least two versions of PostgreSQL. We most often support more than 2 PostgreSQL versions, if requirements do not necessitate bumping up requirement without too much effort. We will rarely support more than 5 PostgreSQL versions on any release.

64-bit Windows version support started in PostGIS 2.0.0 (both 9.0 and 9.1)

Versions of GEOS support for PostGIS

The below chart shows which versions of GEOS work with which versions of PostGIS. The 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.

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.

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

3.10

No

No

No

No

No

No

No

No

No

Yes*

Yes

Yes

3.9

No

No

No

No

No

No

No

No

No

Yes

Yes

Yes

3.8

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

3.7

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

3.6

Yes

Yes

Yes

Yes

Yes

Yes

Yes (recommended)

Yes*

Yes*

3.5

Yes

Yes

Yes

Yes

Yes

Yes (recommended)

Yes*

Yes*

Yes*

3.4

Yes

Yes

Yes (preferred 3.4.2+)

Yes (3.4.2+)

Yes

Yes*

Yes*

Yes*

No

3.3 EOL

Yes

Yes

Yes (preferred 3.3.3+)

Yes (3.3.9+)

Yes (not recommended)

Yes*

No

No

No

3.2 EOL

Yes

Yes

Yes

Yes (not recommended)

No

No

No

No

No

3.1 EOL

Yes

Yes

Yes (not recommended) (requires 3.1.1+)

No

No

No

No

No

No

3.0 EOL

Yes

Yes (not recommended)

No

No

No

No

No

No

No

2.2 EOL

Yes (not recommended)

No

No

No

No

No

No

No

No

None

Yes (not recommended)

No

No

No

No

No

No

No

No

Versions of GDAL support for PostGIS

PostGIS raster functionality (introduced in 2.0) depends on GDAL so to get raster functionality, you'll need to compile with GDAL support and preferably 1.9 or above. Although you can compile PostGIS 2.0 without raster support, you really should rethink that decision, especially if you are a package maintainer (you'll have a lot of pissed off users if you do ). For PostgreSQL 9.1 extension support, compiling with raster support is ABSOLUTELY required since the postgis extension includes the raster functionality.

^* Means it currently does or doesn't but may change at release time.

GDAL Version	Pre - PostGIS 2.0	PostGIS 2.0	PostGIS 2.1	PostGIS 2.2	PostGIS 2.3	PostGIS 2.4
2.2	N/A	No	No	Yes	Yes	Yes
2.1	N/A	No	No	Yes	Yes	Yes
2.0	N/A	No	No	Yes	Yes	Yes
1.11	N/A	Yes	Yes	Yes	Yes	Yes
1.10	N/A	Yes	Yes	Yes	Yes	Yes
1.9	N/A	Yes	Yes	Yes	Yes
1.8	N/A	Yes (not recommended)	Yes (not recommended)	Yes*	Yes*
1.7	N/A	Yes (not recommended)	No	No	No

Packaging status

See UsersWikiPackages