wiki:UsersWikiPostgreSQLPostGIS

Version 22 (modified by robe, 12 years ago) (diff)

--

Versions of PostgreSQL supported by which versions of PostGIS

PostgreSQL VersionPostGIS 1.3PostGIS 1.4PostGIS 1.5
7.2-7.4Yes (not windows)NoNo
8.0Yes (not windows)NoNo
8.1YesNoNo
8.2YesYesNo
8.3YesYesYes
8.4YesYesYes
8.5NoNoYes

The alpha development releases of PostgreSQL 8.5 has been tested but not extensively against PostGIS 1.5, fixes have already been incorporated to make it compile against PostGIS 1.5. These fixes have not been and probably will not be back-ported to pre-PostGIS 1.5 releases.

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 such as ST_Covers, ST_CoversBy and for PostGIS 1.5 the ST_HausdorffDistance and enhancements to ST_Buffer (both speed and functionality). GEOS 3.1 brought cascade union. GEOS 3.2 brought faster buffering and buffering enhancements, plus numerous enhancements with dealing with tolerance issues when unioning.

Geos VersionPostGIS 1.3PostGIS 1.4PostGIS 1.5
NoneYes (not recommended)NoNo
2.2Yes (not recommended)NoNo
3.0YesYes (not recommended)No
3.1YesYesYes (not recommended) (requires 3.1.1+
3.2YesYesYes