PostGIS Development Blog http://postgis.net/ 2017-11-19T15:05:07+00:00 PieCrust 1.2.0 PostGIS Patch Releases 2017-11-15T00:00:00+00:00 2017-11-15T00:00:00+00:00 /2017/11/15/postgis-patches Paul Ramsey Paul Ramseyhttp://postgis.net <p>The PostGIS development team has uploaded bug fix releases for the 2.3 and 2.4 stable branches.</p> <p><strong>2.3.5</strong></p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.5.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.5/NEWS">NEWS</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.5/ChangeLog">Changelog</a></li> </ul> <p><strong>2.4.2</strong></p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.2.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.2/NEWS">NEWS</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.2/ChangeLog">Changelog</a></li> </ul> Move PostGIS extension to a different schema 2017-11-07T00:00:00+00:00 2017-11-07T00:00:00+00:00 /2017/11/07/tip-move-postgis-schema Regina Obe Regina Obehttp://postgis.net <p>As of PostGIS 2.3, the postgis extension was changed to no longer allow relocation. All function calls within the extension are now schema qualified.</p> <p>While this change fixed some issues with database restore, it created the issue of if you installed PostGIS in a schema other than the one you wanted to it is not intuitive how to move it to a different schema. Luckily there is a way to do this.</p> <p>For this exercise, I will install PostGIS in the default schema and then demonstrate how to move it into another schema location.</p> <p>You can run these steps using psql or pgAdmin or any other PostgreSQL tool you want.</p> Continue Reading by clicking title hyperlink .. PostGIS Patch Releases 2017-10-18T00:00:00+00:00 2017-10-18T00:00:00+00:00 /2017/10/18/postgis-patches Paul Ramsey Paul Ramseyhttp://postgis.net <p>The PostGIS development team has uploaded bug fix releases for the 2.2, 2.3 and 2.4 stable branches.</p> <p><strong>2.2.6</strong></p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.2.6.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.6/NEWS">NEWS</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.2.6/ChangeLog">Changelog</a></li> </ul> <p><strong>2.3.4</strong></p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.3.4.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.4/NEWS">NEWS</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.3.4/ChangeLog">Changelog</a></li> </ul> <p><strong>2.4.1</strong></p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.1.tar.gz">Download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.1/NEWS">NEWS</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.4.1/ChangeLog">Changelog</a></li> </ul> PostGIS 2.4.0 Released 2017-09-30T00:00:00+00:00 2017-09-30T00:00:00+00:00 /2017/09/30/postgis-2.4.0 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10rc1</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0">pgRouting 2.5.0</a>. See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0/NEWS">news file</a>.</p> <p><strong>IMPORTANT NOTES</strong></p> <p>If you are upgrading from an existing PostGIS install, make sure after installing PostGIS binaries 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 have additional postgishy extensions below upgrade them too</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>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION pgrouting <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>In order to have Map Box Vector Tiles support enabled, you&#8217;ll need to compile with protobuf support and pkg-config to verify the correct minimum version of protobuf-c see <a href="https://github.com/protobuf-c/protobuf-c">protobuf</a> for details. <a href="/docs/ST_FrechetDistance.html" target="_blank"><code>ST_FrechetDistance</code></a> function will not be enabled if PostGIS is compiled with lower than GEOS 3.7.0. GEOS 3.7.0 is not released yet but is expected sometime next month.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0.tar.gz">html doc download</a> (this version includes <a href="/docs/manual-2.4/postgis-ja.html">Japanese</a>, <a href="/docs/manual-2.4/postgis-de.html">German</a>, <a href="/docs/manual-2.4/postgis-br.html">Portuguese</a>, and <a href="/docs/manual-2.4/postgis-ko_KR.html">Korean</a> translation files)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0.epub">epub doc download</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0/ChangeLog">ChangeLog</a></li> <li>pgsql help files for non-english languages: <a href="/stuff/pgsql-help-2.4-ja.tar.gz">ja</a>, <a href="/stuff/pgsql-help-2.4-de.tar.gz">de</a>, <a href="/stuff/pgsql-help-2.4-br.tar.gz">br</a>, <a href="/stuff/pgsql-help-2.4-ko_KR.tar.gz">ko_KR</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.4.0rc3 Released 2017-09-27T00:00:00+00:00 2017-09-27T00:00:00+00:00 /2017/09/27/postgis-2.4.0rc3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0rc3. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10rc1</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0">pgRouting 2.5.0</a>. See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc3/NEWS">news file</a>.</p> <p>This will be the final rc before we have our 2.4.0 release.</p> <p>We encourage everyone to test and in particular package maintainers to ensure no surprises at final release time. </p> <p><strong>IMPORTANT NOTES</strong></p> <p>If you are upgrading from an existing PostGIS install, make sure after installing PostGIS binaries 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 have additional postgishy extensions below upgrade them too</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>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION pgrouting <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0rc3.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0rc3.tar.gz">html doc download</a> (this version includes Japanese, German, Portugese and Korean single html files)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc3.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc3.epub">epub doc download</a></li> <li>pgsql help files for non-english languages: <a href="/stuff/pgsql-help-2.4-ja.tar.gz">ja</a>, <a href="/stuff/pgsql-help-2.4-de.tar.gz">de</a>, <a href="/stuff/pgsql-help-2.4-br.tar.gz">br</a>, <a href="/stuff/pgsql-help-2.4-ko_KR.tar.gz">ko_KR</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc3/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.4.0rc2 Released 2017-09-24T00:00:00+00:00 2017-09-24T00:00:00+00:00 /2017/09/24/postgis-2.4.0rc2 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0rc2. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10rc1</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0">pgRouting 2.5.0</a>. See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc2/NEWS">news file</a>.</p> <p>We encourage everyone to test and in particular package maintainers to insure no surprises at final release time. </p> <p><strong>IMPORTANT NOTES</strong></p> <p>If you are upgrading from an existing PostGIS install, make sure after installing PostGIS binaries 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 have additional postgishy extensions below upgrade them too</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>; <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION pgrouting <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0rc2.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0rc2.tar.gz">html doc download</a> (this version includes Japanese, German, Portugese and Korean single html files)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc2.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc2.epub">epub doc download</a></li> <li>pgsql help files for non-english languages: <a href="/stuff/pgsql-help-2.4-ja.tar.gz">ja</a>, <a href="/stuff/pgsql-help-2.4-de.tar.gz">de</a>, <a href="/stuff/pgsql-help-2.4-br.tar.gz">br</a>, <a href="/stuff/pgsql-help-2.4-ko_KR.tar.gz">ko_KR</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc2/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.1.9 Released 2017-09-19T00:00:00+00:00 2017-09-19T00:00:00+00:00 /2017/09/19/postgis-2.1.9 Paul Ramsey Paul Ramseyhttp://postgis.net <p>The PostGIS development team has uploaded the final release of the PostGIS 2.1 branch. The 2.1 branch is now end-of-life. 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.1.9.tar.gz">Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.1.9.tar.gz">html doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.1.9.pdf">pdf doc download</a></li> <li><a href="https://svn.osgeo.org/postgis/tags/2.1.9/ChangeLog">Changelog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.4.0rc1 Released 2017-09-13T00:00:00+00:00 2017-09-13T00:00:00+00:00 /2017/09/13/postgis-2.4.0rc1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0rc1. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10beta4 or rc1 which is coming soon</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0-rc">pgRouting 2.5.0rc</a> 2.5.0 release is eminent. See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc1/NEWS">news file</a>.</p> <p>We encourage everyone to test and in particular package maintainers to insure no surprises at final release time. </p> <p><strong>IMPORTANT NOTES</strong></p> <p>If you are upgrading from an existing PostGIS install, make sure after installing PostGIS 2.4.0rc1 binaries 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 have additional postgishy extensions below upgrade them too</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>; <span style="color: #808080; font-style: italic;">--pgRouting 2.5.0 is imminent</span> <span style="color: #993333; font-weight: bold;">ALTER</span> EXTENSION pgrouting <span style="color: #993333; font-weight: bold;">UPDATE</span>;</pre> <p>In order to have Map Box Vector Tiles support enabled, you&#8217;ll need to compile with protobuf support and pkg-config to verify the correct minimum version of protobuf-c see <a href="https://github.com/protobuf-c/protobuf-c">protobuf</a> for details. ST_FrechetDistance function will not be enabled if PostGIS is compiled with lower than GEOS 3.7.0. GEOS 3.7.0 will probably not be released before PostGIS 2.4.0 is out.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0rc1.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0rc1.tar.gz">html doc download</a> (this version includes Japanese translation postgis-ja.html)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc1.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0rc1.epub">epub doc download</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0rc1/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.4.0beta1 Released 2017-09-02T00:00:00+00:00 2017-09-02T00:00:00+00:00 /2017/09/02/postgis-2.4.0beta1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0beta1. PostGIS 2.4.0 will be the first version to support PostgreSQL 10. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10beta4</a> and <a href="https://github.com/pgRouting/pgrouting/releases/tag/v2.5.0-beta">pgRouting 2.5.0beta</a> See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0beta1/NEWS">news file</a>.</p> <p>We encourage everyone to test and in particular package maintainers to insure no surprises at final release time. </p> <p><strong>IMPORTANT NOTES</strong></p> <p>From this point forward until release of PostGIS 2.4.0, no new functions will be added.<br /> Only bug fixes will be addressed in future 2.4.0 betas and rcs. </p> <p>In order to have Map Box Vector Tiles support enabled, you&#8217;ll need to compile with protobuf support and pkg-config to verify the correct minimum version of protobuf-c see <a href="https://github.com/protobuf-c/protobuf-c">protobuf</a> for details. ST_FrechetDistance function will not be enabled if PostGIS is compiled with lower than GEOS 3.7.0. GEOS 3.7.0 will be released around the same time as PostGIS 2.4.0 and will have a beta release in a week.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0beta1.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0beta1.tar.gz">html doc download</a> (this version includes Japanese translation postgis-ja.html)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0beta1.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0beta1.epub">epub doc download</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0beta1/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink .. PostGIS 2.4.0alpha Released 2017-08-05T00:00:00+00:00 2017-08-05T00:00:00+00:00 /2017/08/05/postgis-2.4.0alpha Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to announce the release of PostGIS 2.4.0alpha. This is the first version to support PostgreSQL 10. Best served with <a href="https://www.postgresql.org/docs/10/static/index.html">PostgreSQL 10beta2</a>. See the full list of changes in the <a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0alpha/NEWS">news file</a>.</p> <ul> <li><a href="http://download.osgeo.org/postgis/source/postgis-2.4.0alpha.tar.gz">Source Download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/doc-html-2.4.0alpha.tar.gz">html doc download</a> (this version includes Japanese translation postgis-ja.html)</li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0alpha.pdf">pdf doc download</a></li> <li><a href="http://download.osgeo.org/postgis/docs/postgis-2.4.0alpha.epub">epub doc download</a></li> <li><a href="https://git.osgeo.org/gogs/postgis/postgis/raw/2.4.0alpha/ChangeLog">ChangeLog</a></li> </ul> Continue Reading by clicking title hyperlink ..