PostGIS Development Blog http://postgis.net/ 2022-01-18T04:15:42+00:00 PieCrust 1.2.0 Upgrading raster from 2.* to 3.* 2022-01-14T00:00:00+00:00 2022-01-14T00:00:00+00:00 /2022/01/14/tip-upgrading-raster-from-2-3 Regina Obe Regina Obehttp://postgis.net <p>As of PostGIS 3.0, the PostGIS raster support is no longer part of the <code>postgis</code> extension, but instead spun off into a new PostGIS extension called <code>postgis_raster</code>.</p> <p>The two main reasons for this break were:</p> <ul> <li><p>Raster functionality in PostGIS is fat with over 150 functions and several types. Wading through these extra functions frustrated many who had no use for rasters.</p></li> <li><p>Raster gdal dependency is very big and many dreamed of having postgis extension without the big raster dependency.</p></li> </ul> <p>While repackaging raster as it&#8217;s own extension resolved many complaints, it meant a slightly more complicated upgrade process going from PostGIS 2.something to 3.something that even experienced PostGIS users managed to screw up.</p> <p>I will detail the proper way of upgrading PostGIS raster, from a PostGIS 2.* install to 3.* install.</p> <p>You can run these steps using psql or pgAdmin or any other PostgreSQL tool you want.</p> <p>Regardless which version of PostGIS you are coming from, you should install the PostGIS 3.* binaries first.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0 Released 2021-12-18T00:00:00+00:00 2021-12-18T00:00:00+00:00 /2021/12/18/postgis-3.2.0 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release PostGIS 3.2.0, the <a href="/2021/12/17/olivier-courtin/">Olivier Courtin</a> release.</p> <p>This release would not be possible without the various developers listed in the credits as well as the companies that provided funding and developer time.</p> <p>Companies that contributed significantly to this release are:</p> <ul> <li><a href="https://www.crunchydata.com/">CrunchyData</a> Geometry processing functions (and improvements to <a href="https://libgeos.org">GEOS</a>, new raster functions, and address_standardizer pcre2 support</li> <li><a href="https://www.kontur.io/">Kontur</a> Speed improvements to raster, MVT, GiST indexing, better usability of geometry processing, and new radius clustering mode.</li> <li><a href="https://strk.kbt.io/services.html">Netlab</a> Continuous improvement of PostGIS topology, PostGIS upgrade plumbing, PostGIS test plumbing, and CI bot management</li> <li><a href="https://nibio.no">NIBIO</a> Developer funding for topology improvements</li> <li><a href="https://www.paragoncorporation.com">Paragon Corporation</a> &#8212; General CI bot management, release management, alignment of PostGIS with PostgreSQL versions.</li> </ul> Continue Reading by clicking title hyperlink .. Olivier Courtin Farewell 2021-12-17T00:00:00+00:00 2021-12-17T00:00:00+00:00 /2021/12/17/olivier-courtin Regina Obe Regina Obehttp://postgis.net <p>In March 2020 we lost a long time PostGIS developer and friend, Olivier Courtin. The PostGIS 3.2.0 release is named in his honor. <br /> <img src="/images/olivier_courtin.png" width="300px" alt="Olivier at Code Sprint"/> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0rc1 Released 2021-12-10T00:00:00+00:00 2021-12-10T00:00:00+00:00 /2021/12/10/postgis-3.2.0rc1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release the first rc of the upcoming PostGIS 3.2.0 release.</p> <p>Best served with <a href="https://www.postgresql.org/docs/14/release.html">PostgreSQL 14</a>. This version of PostGIS can utilize the faster GiST building support API introduced in PostgreSQL 14. If compiled with recently released <a href="https://lists.osgeo.org/pipermail/geos-devel/2021-November/010556.html">GEOS 3.10.1</a> you can take advantage of improvements in ST_MakeValid and numerous speed improvements. This release also includes many additional functions and improvements for <code>postgis</code>, <code>postgis_raster</code> and <code>postgis_topology</code> extensions and a new input/export format <a href="https://flatgeobuf.org/">FlatGeobuf</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0beta3 Released 2021-12-04T00:00:00+00:00 2021-12-04T00:00:00+00:00 /2021/12/04/postgis-3.2.0beta3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release the third beta of the upcoming PostGIS 3.2.0 release.</p> <p>Best served with <a href="https://www.postgresql.org/docs/14/release.html">PostgreSQL 14</a>. This version of PostGIS can utilize the faster GiST building support API introduced in PostgreSQL 14. If compiled with recently released <a href="https://lists.osgeo.org/pipermail/geos-devel/2021-November/010556.html">GEOS 3.10.1</a> you can take advantage of improvements in ST_MakeValid and numerous speed improvements. This release also includes many additional functions and improvements for <code>postgis</code>, <code>postgis_raster</code> and <code>postgis_topology</code> extensions and a new input/export format <a href="https://flatgeobuf.org/">FlatGeobuf</a>.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0beta2 Released 2021-11-26T00:00:00+00:00 2021-11-26T00:00:00+00:00 /2021/11/26/postgis-3.2.0beta2 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release the second beta of the upcoming PostGIS 3.2.0 release.</p> <p>Best served with <a href="https://www.postgresql.org/docs/14/release.html">PostgreSQL 14</a>. This version of PostGIS utilizes the faster GiST building support API introduced in PostgreSQL 14. If compiled with recently released <a href="https://lists.osgeo.org/pipermail/geos-devel/2021-November/010556.html">GEOS 3.10.1</a> you can take advantage of improvements in ST_MakeValid and numerous speed improvements. This release also includes many additional functions and improvements for <code>postgis_raster</code> and <code>postgis_topology</code> extensions.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0beta1 Released 2021-10-23T00:00:00+00:00 2021-10-23T00:00:00+00:00 /2021/10/23/postgis-3.2.0beta1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release the first beta of the upcoming PostGIS 3.2.0 release.</p> <p>Best served with <a href="https://www.postgresql.org/docs/14/release.html">PostgreSQL 14</a>. This version of PostGIS utilizes the faster GiST building support API introduced in PostgreSQL 14. If compiled with recently released <a href="https://lists.osgeo.org/pipermail/geos-devel/2021-October/010484.html">GEOS 3.10.0</a> you can take advantage of improvements in ST_MakeValid and numerous speed improvements. This release also includes many additional functions and improvements for <code>postgis_raster</code> and <code>postgis_topology</code> extensions.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.2.0alpha1 Released 2021-09-11T00:00:00+00:00 2021-09-11T00:00:00+00:00 /2021/09/11/postgis-3.2.0alpha1 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release the first alpha of the upcoming PostGIS 3.2.0 release.</p> <p>Best served with <a href="https://www.postgresql.org/docs/14/release.html">PostgreSQL 14 beta3</a>. This version of PostGIS utilizes the faster GiST building support API introduced in PostgreSQL 14. If compiled with the in-development <a href="https://lists.osgeo.org/pipermail/geos-devel/2021-September/010315.html">GEOS 3.10dev</a> you can take advantage of improvements in ST_MakeValid. This release also includes many additional functions and improvements for <code>postgis_raster</code> and <code>postgis_topology</code> extensions.</p> Continue Reading by clicking title hyperlink .. PostGIS 3.1.4, 3.0.4 Released 2021-09-04T00:00:00+00:00 2021-09-04T00:00:00+00:00 /2021/09/04/postgis-patches Regina Obe Regina Obehttp://postgis.net <p>The PostGIS development team is pleased to provide bug fix and performance enhancements 3.1.4 and 3.0.4 for the 3.1, 3.0 stable branches.</p> <p><!-- pagebreak --> <strong>3.1.4</strong> This release supports PostgreSQL 9.6-14.</p> <ul> <li><a href="https://download.osgeo.org/postgis/source/postgis-3.1.4.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.4/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-3.1.4.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-3.1.4.tar.gz">html doc download</a></li> <li>html online <a href="/docs/manual-3.1">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-3.1.4.epub">epub doc download</a></li> </ul> <p><strong>3.0.4</strong> This release works with PostgreSQL 9.5-13 and GEOS >= 3.6 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.4.tar.gz">source download</a></li> <li><a href="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.4/NEWS">NEWS</a></li> <li>PDF docs <a href="https://download.osgeo.org/postgis/docs/postgis-3.0.4.pdf">en</a></li> <li><a href="https://download.osgeo.org/postgis/docs/doc-html-3.0.4.tar.gz">html doc download</a></li> <li><a href="https://download.osgeo.org/postgis/docs/postgis-3.0.4.epub">epub doc download</a></li> </ul> <p>View all <a href="https://trac.osgeo.org/postgis/query?status=closed&amp;resolution=fixed&amp;milestone=PostGIS+3.1.4&amp;milestone=PostGIS+3.0.4&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.1.4, 3.0.4</a>.</p> <p>After installing the binaries or after running pg_upgrade:</p> <p>For PostGIS 3.1, 3.0, 2.5 do below which will upgrade all your postgis extensions.</p> <pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> postgis_extensions_upgrade<span style="color: #66cc66;">&#40;</span><span style="color: #66cc66;">&#41;</span>;</pre> <p>For PostGIS 2.4 and below 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.1.3 2021-07-02T00:00:00+00:00 2021-07-02T00:00:00+00:00 /2021/07/02/postgis-3.1.3 Regina Obe Regina Obehttp://postgis.net <p>The PostGIS Team is pleased to release PostGIS 3.1.3! Best Served with PostgreSQL 14 beta2.</p> <p>This release is a bug fix release, addressing issues found in the previous 3.1 release.</p> <ul> <li><p><a href="https://trac.osgeo.org/postgis/ticket/4929">#4929</a>, Fix missing error from GetRingEdges when invoked with unexistent topology or edge (Sandro Santilli)</p></li> <li><p><a href="https://trac.osgeo.org/postgis/ticket/4927">#4927</a>, Fix PostgreSQL 14 compile FuncnameGetCandidates changes needed to compile against PostgreSQL 14 beta2 or higher (Regina Obe, Julien Rouhaud)</p></li> </ul> Continue Reading by clicking title hyperlink ..