PostGIS Development Blog http://postgis.net/ 2017-07-25T17:25:08+00:00 PieCrust 1.2.0 PostGIS 2.3.3 Released 2017-07-01T00:00:00+00:00 2017-07-01T00:00:00+00:00 /2017/07/01/postgis-2.3.3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.3.3 As befits a patch release, the focus is on bugs and breakages. Best served with <a href="https://www.postgresql.org/docs/9.6/static/release-9-6-3.html">PostgreSQL 9.6.3+</a> and <a href="http://docs.pgrouting.org/2.4/en/release_notes.html#changelog-2-4-1">pgRouting 2.4.1</a>.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.3.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.3.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.3.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.3.epub">epub doc download</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.3.3/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink .. Causes for 'postgis.backend' is already set 2017-06-05T00:00:00+00:00 2017-06-05T00:00:00+00:00 /2017/06/05/postgis-backend-is-already-set Regina Obe Regina Obehttp://postgis.net <p>The error &#8216;postgis.backend&#8217; is already set comes up every so often in PostGIS mailing list. The issue arises often during or after an upgrade. I&#8217;ll go over causes for this I am aware of and how to fix.</p> <p>The question goes something like this</p> <p><em> After upgrading to Postgis 2.3 from 2.1, my server log is filled with these messages :</p> <p>&#8220;WARNING &#8216;postgis.backend&#8217; is already set and cannot be changed until you reconnect&#8221;</em></p> Continue Reading by clicking title hyperlink .. PostGIS 2.3.2 Released 2017-01-31T00:00:00+00:00 2017-01-31T00:00:00+00:00 /2017/01/31/postgis-2.3.2 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.3.2 As befits a patch release, the focus is on bugs and breakages. Best served with <a href="https://www.postgresql.org/about/news/1712/">PostgreSQL 9.6.1+</a> and <a href="https://lists.osgeo.org/pipermail/pgrouting-users/2017-January/002304.html">pgRouting 2.3.2</a>.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.2.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.2.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.2.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.2.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.2/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.2.5 Released 2017-01-30T00:00:00+00:00 2017-01-30T00:00:00+00:00 /2017/01/30/postgis-2.2.5 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.2.5 As befits a patch release, the focus is on bugs and breakages.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.5.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.2.5.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.2.5.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.5/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.3.1 Released 2016-11-28T00:00:00+00:00 2016-11-28T00:00:00+00:00 /2016/11/28/postgis-2.3.1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.3.1. Best served with <a href="https://lists.osgeo.org/pipermail/pgrouting-dev/2016-November/001721.html">pgRouting 2.3.1</a> and <a href="https://www.postgresql.org/about/news/1712">PostgreSQL 9.6.1</a>.</p> <p>As befits a patch release, the focus is on bugs and breakages.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.1.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.1.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.1.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.1/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.2.4 Released 2016-11-26T00:00:00+00:00 2016-11-26T00:00:00+00:00 /2016/11/26/postgis-2.2.4 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.2.4 As befits a patch release, the focus is on bugs and breakages.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.4.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.2.4.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.2.4.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.4/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.2.3 Released 2016-10-06T00:00:00+00:00 2016-10-06T00:00:00+00:00 /2016/10/06/postgis-2.2.3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.2.3 As befits a patch release, the focus is on bugs and breakages.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.3.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.2.3.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.2.3.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.3/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.3.0 Released 2016-09-26T00:00:00+00:00 2016-09-26T00:00:00+00:00 /2016/09/26/postgis-2.3.0 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.3.0.<br /> This is the first version to utilize the parallel support functionality introduced in PostgreSQL 9.6. As such, if you are using PostgreSQL 9.6, we strongly encourage you to use this version.</p> <p>Parallel support will make many queries using PostGIS relationship operators and functions faster. In order to take advantage of parallel query support, make sure to set <code>max_parallel_workers_per_gather</code> to something greater than 0 as noted in <a href="https://www.postgresql.org/docs/9.6/static/runtime-config-resource.html#GUC-MAX-PARALLEL-WORKERS-PER-GATHER"><code>max_parallel_workers_per_gather</code> PostgreSQL runtime configs</a></p> <p>Best served with [PostgreSQL 9.6+] which is due out this week and <a href="https://lists.osgeo.org/pipermail/pgrouting-users/2016-September/002287.html">pgRouting 2.3.0</a> which also just got released.</p> <p>Packages from maintainers will be out in the coming days and weeks.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.0.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.0.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.0.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.0/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.3.0rc1 Released 2016-09-19T00:00:00+00:00 2016-09-19T00:00:00+00:00 /2016/09/19/postgis-2.3.0rc1 Regina Obe Regina Obehttp://postgis.net <p>PostGIS 2.3.0rc1 is feature complete, so we&#8217;re looking for testing and feedback! Best served with <a href="https://www.postgresql.org/about/news/1693/">PostgreSQL 9.6rc1</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/pgrouting-2.3.0-rc1">pgRouting 2.3.0-rc1</a></p> <p>Please give this release candidate a try and report back any issues you encounter. New things since 2.3.0beta1 release</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.0rc1.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.0rc1.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.0rc1.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.0rc1/ChangeLog">Changelog</a></li> </ul> <p>Please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in this release.</p> <p><strong>Important / Breaking Changes</strong></p> <ul> <li><p>3466, Casting from box3d to geometry now returns a 3D geometry (Julien Rouhaud of Dalibo)</p></li> <li><p>3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to wrong liblwgeom.h (Greg Troxel)</p></li> <li><p>3396, ST_EstimatedExtent, now throws WARNING instead of ERROR (Regina Obe)</p> <p><strong>New Features and Performance Enhancements</strong></p></li> <li><p>Add support for custom TOC in postgis_restore.pl (Christoph Moench-Tegeder)</p></li> <li>Add support for negative indexing in ST<em>PointN and ST</em>SetPoint (Rémi Cura)</li> <li><p>Numerous new function additions and enhancements: <a href="http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions_2_3">New Functions and Enhancements</a></p></li> <li><p>3549, Support PgSQL 9.6 parallel query mode, as far as possible (Paul Ramsey, Regina Obe)</p></li> <li>3557, Geometry function costs based on query stats (Paul Norman)</li> <li>3591, Add support for BRIN indexes (Giuseppe Broccolo of 2nd Quadrant, Julien Rouhaud and Ronan Dunklau of Dalibo)</li> <li><p>3496, Make postgis non-relocateable (for extension install), schema qualify calls in functions (Regina Obe) Should resolve once and for all for extensions <a href="https://trac.osgeo.org/postgis/ticket/3494">#3494</a>, <a href="https://trac.osgeo.org/postgis/ticket/3486">#3486</a>, <a href="https://trac.osgeo.org/postgis/ticket/3076">#3076</a> </p></li> <li><p>3547, Update tiger geocoder to support TIGER 2016 and use http or ftp (Regina Obe)</p></li> </ul> <p>See the full list of changes in the <a href="http://svn.osgeo.org/postgis/tags/2.3.0rc1/NEWS">news file</a> and please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in the release. Binary packages will appear in <a href="http://postgis.net/install">repositories</a> over the coming weeks as packagers roll out builds.</p> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.3.0&amp;order=priority">closed tickets for 2.3.0</a>.</p> PostGIS 2.3.0beta1 Released 2016-09-06T00:00:00+00:00 2016-09-06T00:00:00+00:00 /2016/09/06/postgis-2.3.0beta1 Regina Obe Regina Obehttp://postgis.net <p>PostGIS 2.3 is feature complete, so we&#8217;re looking for testing and feedback! Best served with PostgreSQL 9.6.</p> <p>Please give this beta a try and report back any issues you encounter. </p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.0beta1.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.3.0beta1.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.3.0beta1.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.0beta1/ChangeLog">Changelog</a></li> </ul> <p>Please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in this release.</p> <p>** Important / Breaking Changes **</p> <ul> <li><p>3466, Casting from box3d to geometry now returns a 3D geometry (Julien Rouhaud of Dalibo)</p></li> <li><p>3604, pgcommon/Makefile.in orders CFLAGS incorrectly leading to wrong liblwgeom.h (Greg Troxel)</p> <p>** New Features and Performance Enhancements **</p></li> <li><p>Add support for custom TOC in postgis_restore.pl (Christoph Moench-Tegeder)</p></li> <li>Add support for negative indexing in ST<em>PointN and ST</em>SetPoint (Rémi Cura)</li> <li><p>Numerous new function additions and enhancements: <a href="http://postgis.net/docs/manual-dev/PostGIS_Special_Functions_Index.html#NewFunctions_2_3">New Functions and Enhancements</a></p></li> <li><p>3549, Support PgSQL 9.6 parallel query mode, as far as possible (Paul Ramsey, Regina Obe)</p></li> <li>3557, Geometry function costs based on query stats (Paul Norman)</li> <li>3591, Add support for BRIN indexes (Giuseppe Broccolo of 2nd Quadrant, Julien Rouhaud and Ronan Dunklau of Dalibo)</li> <li><p>3496, Make postgis non-relocateable (for extension install), schema qualify calls in functions (Regina Obe) Should resolve once and for all for extensions <a href="https://trac.osgeo.org/postgis/ticket/3494">#3494</a>, <a href="https://trac.osgeo.org/postgis/ticket/3486">#3486</a>, <a href="https://trac.osgeo.org/postgis/ticket/3076">#3076</a> </p></li> <li><p>3547, Update tiger geocoder to support TIGER 2016 and use http or ftp (Regina Obe)</p></li> </ul> <p>See the full list of changes in the <a href="http://svn.osgeo.org/postgis/tags/2.3.0beta1/NEWS">news file</a> and please <a href="https://trac.osgeo.org/postgis">report bugs</a> that you find in the release. Binary packages will appear in <a href="http://postgis.net/install">repositories</a> over the coming weeks as packagers roll out builds.</p> <p>View all <a href="http://trac.osgeo.org/postgis/query?status=closed&amp;groupdesc=1&amp;group=priority&amp;milestone=PostGIS+2.3.0&amp;order=priority">closed tickets for 2.3.0</a>.</p>