Foreign Data Wrappers for PostGIS

The last couple weeks have seen two interesting updates in the world of PostgreSQL “foreign data wrappers” (FDW). Foreign data wrappers allow you to access remote data inside your database, exactly like other tables. PostgreSQL ships with two example implementations, one for accessing text files, and the other for accessing remote PostgreSQL servers. The two updates of interest to PostGIS users are: The Oracle FDW implementation was recently enhanced to support spatial columns, so an Oracle table with SDO_GEOMETRY columns can be exposed in PostgreSQL as a table with PostGIS geometry columns.

PostGIS 2.1.5 Released

The 2.1.5 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.5 release. As befits a patch release, the focus is on bugs, breakages, and performance issues

<https://download.osgeo.org/postgis/source/postgis-2.1.5.tar.gz>

PostGIS 2.1.4 Released

The 2.1.4 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.4 release. As befits a patch release, the focus is on bugs, breakages, and performance issues

<https://download.osgeo.org/postgis/source/postgis-2.1.4.tar.gz>

Security releases 2.0.6 and 2.1.3

It has come to our attention that the PostGIS Raster support may give more privileges to users than an administrator is willing to grant. These include reading files from the filesystem and opening connections to network hosts.

PostGIS 2.0.5 Released

The 2.0.5 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.0, the 2.0.5 release. As befits a patch release, the focus is on bugs and breakages.

Best served with a bottle of GEOS 3.3.9.

<https://download.osgeo.org/postgis/source/postgis-2.0.5.tar.gz>

Doc downloads: html doc download pdf doc download

PostGIS 2.1.2 Released

The 2.1.2 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.2 release. As befits a patch release, the focus is on bugs and breakages.

Best served with a bottle of GEOS 3.4.2.

<https://download.osgeo.org/postgis/source/postgis-2.1.2.tar.gz>

PostGIS 2.1.1 Released

The 2.1.1 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.1 release. As befits a patch release, the focus is on bugs and breakages.

Best served with a bottle of GEOS 3.4.2.

<https://download.osgeo.org/postgis/source/postgis-2.1.1.tar.gz>

PostGIS 2.0.4 Released

The 2.0.4 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2, the 2.0.4 release. As befits a patch release, the focus is on bugs and breakages.

Best served with a bottle of GEOS 3.3.9.

<https://download.osgeo.org/postgis/source/postgis-2.0.4.tar.gz>

Doc downloads: html doc download pdf doc download

PostGIS 2.1.0 Released

The 2.1.0 release of PostGIS is now available.

The PostGIS development team is proud to release PostGIS 2.1.0. As befits a minor release, the focus is on speed improvements, more features, and bug fixes.

If you are currently using PostGIS 2.0+, you can go the soft upgrade path:

ALTER EXTENSION postgis UPDATE TO "2.1.0";

If you are running 2.1.0 of beta or an unreleased version (and the above step fails with error “extension postgis has no update path from version x.x.x to version 2.1.0”) , you need to first copy the file in share\extensions\postgis–2.0.3–2.1.0.sql and change the 2.0.3 to the x.x.x noted in the error you are running. Then follow the above upgrade step again.

Users of 1.5 and below will need to go the hard-upgrade path documented in manual:

http://postgis.net/docs/manual-2.1/postgis_installation.html#hard_upgrade

Best served with a bottle of GEOS 3.4.1 and PostgreSQL 9.3beta2 (planned release September).

PostGIS 2.1.0rc2 Released

The 2.1.0rc2 release of PostGIS is now available.

The PostGIS development team is proud to release a release candidate version of upcoming PostGIS 2.1.0. As befits a minor release, the focus is on speed improvements, more features, and bug fixes. We expect this to be the final release candidate before we officially release 2.1.0 slated for Aug 12th, 2013. We’d appreciate it if you test it before final release and report back with any issues you run into so we can have a smooth release.

If you are currently using PostGIS 2.0 (or 2.1.0 beta3+) using extension support, you can go the soft upgrade path:

ALTER EXTENSION postgis UPDATE TO "2.1.0rc2";

If you are running 2.1.0 of beta or an unreleased version (and the above step fails with error “extension postgis has no update path from version x.x.x to version 2.1.0rc2”) , you need to first copy the file in share\extensions\postgis–2.0.3–2.1.0rc2.sql and change the 2.0.3 to the x.x.x noted in the error you are running. Then follow the above upgrade step again.

Users of 1.5 and below will need to go the hard-upgrade path.

Best served with a bottle of GEOS 3.4.0 (planned release Aug 11th) and PostgreSQL 9.3beta2.