PostGIS Development Blog http://postgis.net/ 2019-11-16T17:50:13+00:00 PieCrust 1.2.0 PostGIS 3.0.0 2019-10-20T00:00:00+00:00 2019-10-20T00:00:00+00:00 /2019/10/20/postgis-3.0.0 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0.</p> <p>This release works with PostgreSQL 9.5-12 and GEOS >= 3.6.</p> <p>If you are using postgis_sfcgal extension, you need to compile against SFCGAL 1.3.1 or higher.</p> <p>Best served with <a href="https://www.postgresql.org/about/news/1976/">PostgreSQL 12</a> , <a href="https://lists.osgeo.org/pipermail/geos-devel/2019-October/009342.html">GEOS 3.8.0</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-beta">pgRouting 3.0.0-beta</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0rc2 2019-10-13T00:00:00+00:00 2019-10-13T00:00:00+00:00 /2019/10/13/postgis-3.0.0rc2 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0rc2. This will be the final RC before release.</p> <p>This release works with PostgreSQL 9.5-12 and GEOS >= 3.6</p> <p>Best served with <a href="https://www.postgresql.org/about/news/1976/">PostgreSQL 12</a> , <a href="https://lists.osgeo.org/pipermail/geos-devel/2019-October/009342.html">GEOS 3.8.0</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-alpha">pgRouting 3.0.0-alpha</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0rc1 2019-10-08T00:00:00+00:00 2019-10-08T00:00:00+00:00 /2019/10/08/postgis-3.0.0rc1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0rc1.</p> <p>This release works with PostgreSQL 9.5-12 and GEOS >= 3.6</p> <p>Best served with <a href="https://www.postgresql.org/about/news/1976/">PostgreSQL 12</a> , <a href="https://lists.osgeo.org/pipermail/geos-devel/2019-October/009288.html">GEOS 3.8.0rc2</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-alpha">pgRouting 3.0.0-alpha</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0beta1 2019-09-28T00:00:00+00:00 2019-09-28T00:00:00+00:00 /2019/09/28/postgis-3.0.0beta1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0beta1.</p> <p>This release works with PostgreSQL 9.5-12RC1 and GEOS >= 3.6</p> <p>Best served with <a href="https://www.postgresql.org/developer/beta/">PostgreSQL 12RC1</a> and <a href="https://lists.osgeo.org/pipermail/geos-devel/2019-September/009267.html">GEOS 3.8.0beta1</a> both of which came out in the past couple of days.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 Released 2019-08-11T00:00:00+00:00 2019-08-11T00:00:00+00:00 /2019/08/11/postgis-patches Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to provide enhancements/features 3.0.0alpha4 for 3.0 feature major branch bug fix 2.5.3, 2.4.8, and 2.3.10 for the 2.5, 2.4, and 2.3 stable branches.</p> <p><!-- pagebreak --> <strong>3.0.0alpha4</strong> This release works with PostgreSQL 9.5-12beta3 and GEOS >= 3.6</p> <p>Best served with <a href="https://www.postgresql.org/developer/beta/">PostgreSQL 12beta3</a>. Designed to take advantage of features in PostgreSQL 12 and Proj 6</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-3.0.0alpha4.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha4/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha4.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-3.0.0alpha4.tar.gz">html doc download</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-3.0.0alpha4.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/3.0.0alpha4/ChangeLog">Changelog</a></li> </ul> <p><strong>2.5.3</strong> This release supports PostgreSQL 9.3-12 You are encouraged to use the PostGIS 3.0 unreleased branch with PostgreSQL 12 , which has features specifically designed to take advantage of features new in PostgreSQL 12.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.5.3.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.3/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.5.3.pdf">en</a> <a href="https://download.osgeo.org/postgis/docs/postgis-2.5.3-de.pdf">de</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.5.3.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.5">en</a> <a href="/docs/manual-2.5/postgis-de.html">de</a> <a href="/docs/manual-2.5/postgis-ja.html">ja</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.5.3.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.5.3/ChangeLog">Changelog</a></li> </ul> <p><strong>2.4.8</strong> This release supports PostgreSQL 9.3-10.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.4.8.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.8/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.4.8.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.4.8.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.4">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.4.8.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.8/ChangeLog">Changelog</a></li> </ul> <p><strong>2.3.10</strong></p> <p>This release supports PostgreSQL 9.2-10.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.3.10.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.3.10/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.3.10.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.3.10.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.3">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.3.10.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.10/ChangeLog">Changelog</a></li> </ul> <p>View all <a href="https://trac.osgeo.org/postgis/query?status=closed&amp;resolution=fixed&amp;milestone=PostGIS+2.3.10&amp;milestone=PostGIS+2.4.8&amp;milestone=PostGIS+2.5.3&amp;milestone=PostGIS+3.0.0&amp;col=id&amp;col=summary&amp;col=milestone&amp;col=status&amp;col=type&amp;col=priority&amp;col=component&amp;order=priority">closed tickets for 3.0.0, 2.5.3, 2.4.8, 2.3.10</a>.</p> <p>After installing the binaries or after running pg_upgrade, make sure to do:</p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>&#8212; if you use the other extensions packaged with postgis &#8212; make sure to upgrade those as well</p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_sfcgal <span style="color: #993333; font-weight: bold;">UPDATE</span>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_topology <span style="color: #993333; font-weight: bold;">UPDATE</span>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_tiger_geocoder <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version packaged with these releases.</p> PostGIS 3.0.0alpha3 2019-07-01T00:00:00+00:00 2019-07-01T00:00:00+00:00 /2019/07/01/postgis-3.0.0alpha3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0alpha3.</p> <p>This release works with PostgreSQL 9.5-12beta2 and GEOS >= 3.6</p> <p>Best served with <a href="https://www.postgresql.org/developer/beta/">PostgreSQL 12beta2</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0alpha2 2019-06-02T00:00:00+00:00 2019-06-02T00:00:00+00:00 /2019/06/02/postgis-3.0.0alpha2 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0alpha2.</p> <p>This release works with PostgreSQL 9.5-12beta1 and GEOS >= 3.6</p> <p>Best served with PostgreSQL 12beta1.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.0.0alpha1 2019-05-26T00:00:00+00:00 2019-05-26T00:00:00+00:00 /2019/05/26/postgis-3.0.0alpha1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to release PostGIS 3.0.0alpha1.</p> <p>This release works with PostgreSQL 9.5-12beta1 and GEOS >= 3.6</p> <p>Best served with PostgreSQL 12beta1.</p> Continue Reading by clicking title hyperlink .. PostGIS 2.5.2, 2.4.7, 2.3.9 Released 2019-03-11T00:00:00+00:00 2019-03-11T00:00:00+00:00 /2019/03/11/postgis-patches Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to provide bug fix 2.5.2, 2.4.7, and 2.3.9 for the 2.5, 2.4, and 2.3 stable branches.</p> <p>These are the first versions to be able to compile against <a href="https://proj4.org/download.html">Proj 6.0.0</a>, You must upgrade to these if you are using Proj 6.</p> <p><!-- pagebreak --> <strong>2.5.2</strong> This release supports PostgreSQL 9.3-11 (will compile against PostgreSQL 12, but not pass tests. Use only for pg_upgrade. You are encouraged to use the PostGIS 3.0 unreleased branch with PostgreSQL 12 , which has features specifically designed to take advantage of features new in PostgreSQL 12).</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.5.2.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.2/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.5.2.pdf">en</a> <a href="https://download.osgeo.org/postgis/docs/postgis-2.5.2-de.pdf">de</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.5.2.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.5">en</a> <a href="/docs/manual-2.5/postgis-de.html">de</a> <a href="/docs/manual-2.5/postgis-ja.html">ja</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.5.2.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.5.2/ChangeLog">Changelog</a></li> </ul> <p><strong>2.4.7</strong> This release supports PostgreSQL 9.3-10.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.4.7.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.7/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.4.7.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.4.7.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.4">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.4.7.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.7/ChangeLog">Changelog</a></li> </ul> <p><strong>2.3.9</strong></p> <p>This release supports PostgreSQL 9.2-10.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-2.3.9.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.3.9/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-2.3.9.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-2.3.9.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-2.3">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-2.3.9.epub">epub doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.9/ChangeLog">Changelog</a></li> </ul> <p>View all <a href="https://trac.osgeo.org/postgis/query?status=closed&amp;resolution=fixed&amp;milestone=PostGIS+2.3.9&amp;milestone=PostGIS+2.4.7&amp;milestone=PostGIS+2.5.2&amp;col=id&amp;col=summary&amp;col=milestone&amp;col=status&amp;col=type&amp;col=priority&amp;col=component&amp;order=priority">closed tickets for 2.5.2, 2.4.7, 2.3.9</a>.</p> <p>After installing the binaries or after running pg_upgrade, make sure to do:</p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>&#8212; if you use the other extensions packaged with postgis &#8212; make sure to upgrade those as well</p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_sfcgal <span style="color: #993333; font-weight: bold;">UPDATE</span>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_topology <span style="color: #993333; font-weight: bold;">UPDATE</span>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION postgis_tiger_geocoder <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>If you use legacy.sql or legacy_minimal.sql, make sure to rerun the version packaged with these releases.</p> PostGIS 2.3.8, 2.4.6 2018-11-24T00:00:00+00:00 2018-11-24T00:00:00+00:00 /2018/11/24/postgis-patches Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to provide bug fix 2.3.8 and 2.4.6 for the 2.3 and 2.4 stable branches.</p> Continue Reading by clicking title hyperlink ..