[postgis-tickets] [SCM] postgis.net branch hugo updated. c71c25760f8a27daac9743e4af5d930e7de166fd
git at osgeo.org
git at osgeo.org
Sun Feb 27 19:28:31 PST 2022
This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".
The branch, hugo has been updated
via c71c25760f8a27daac9743e4af5d930e7de166fd (commit)
from 630e41a19bff5bad1172847f65105949e529c3c6 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
commit c71c25760f8a27daac9743e4af5d930e7de166fd
Author: Regina Obe <lr at pcorp.us>
Date: Sun Feb 27 22:28:18 2022 -0500
More article conversions
diff --git a/content/pages/windows_downloads.md b/content/pages/windows_downloads.md
index 9a45803..aafbf29 100644
--- a/content/pages/windows_downloads.md
+++ b/content/pages/windows_downloads.md
@@ -79,7 +79,7 @@ Setup is detailed in [Starting PostgreSQL in windows without install](http://www
PostGIS is an optional extension that must be enabled in EVERY database you want to use it in.
-{% geshi 'sql' %}
+```postgres
CREATE EXTENSION postgis;
-- in PostGIS 3, postgis_raster is a separate extension from postgis
-- so do this in addition if you are experimenting PostGIS 3+
@@ -90,14 +90,14 @@ CREATE EXTENSION address_standardizer;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION postgis_tiger_geocoder;
-{% endgeshi %}
+```
If you want to use pgrouting, download the respective one for your PostgreSQL/
-{% geshi 'sql' %}
+```postgres
CREATE EXTENSION pgrouting;
-{% endgeshi %}
+```
For loading OpenStreetMap data (OSM) into pgrouting format, you can use osm2po or [osm2pgrouting][10].
Windows binaries for osm2pgrouting can be found in the `extras` folder of each version. Refer to instructions in the zip.
diff --git a/content/post/2019/03-11_postgis-patches.md b/content/post/2019/03-11_postgis-patches.md
new file mode 100644
index 0000000..b303e41
--- /dev/null
+++ b/content/post/2019/03-11_postgis-patches.md
@@ -0,0 +1,77 @@
+---
+title: PostGIS 2.5.2, 2.4.7, 2.3.9 Released
+layout: post
+category: news
+tags: [release,2.5,2.4,2.3,2.5.2,2.4.7,2.3.9]
+author: Regina Obe
+date: "2019-03-11"
+thumbnail: postgis.png
+---
+
+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.
+
+These are the first versions to be able to compile against [Proj 6.0.0](https://proj4.org/download.html),
+You must upgrade to these if you are using Proj 6.
+
+<!-- pagebreak -->
+**2.5.2**
+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).
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.5.2.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.2/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.5.2.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-2.5.2-de.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.5.2.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.5) [de]({{< loc "site.root">}}docs/manual-2.5/postgis-de.html) [ja]({{< loc "site.root">}}docs/manual-2.5/postgis-ja.html)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.5.2.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.5.2/ChangeLog)
+
+**2.4.7**
+This release supports PostgreSQL 9.3-10.
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.4.7.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.7/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.4.7.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.4.7.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.4)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.4.7.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.4.7/ChangeLog)
+
+**2.3.9**
+
+This release supports PostgreSQL 9.2-10.
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.3.9.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.3.9/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.3.9.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.3.9.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.3)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.3.9.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.3.9/ChangeLog)
+
+
+View all [closed tickets for 2.5.2, 2.4.7, 2.3.9][1].
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+```
+
+-- if you use the other extensions packaged with postgis
+-- make sure to upgrade those as well
+
+```postgres
+ALTER EXTENSION postgis_sfcgal UPDATE;
+ALTER EXTENSION postgis_topology UPDATE;
+ALTER EXTENSION postgis_tiger_geocoder UPDATE;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+2.3.9&milestone=PostGIS+2.4.7&milestone=PostGIS+2.5.2&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/05-26_postgis-3.0.0alpha1.md b/content/post/2019/05-26_postgis-3.0.0alpha1.md
new file mode 100644
index 0000000..51ab341
--- /dev/null
+++ b/content/post/2019/05-26_postgis-3.0.0alpha1.md
@@ -0,0 +1,57 @@
+---
+title: PostGIS 3.0.0alpha1
+layout: post
+category: news
+tags: [release,3.0, 3.0.0alpha1]
+author: Regina Obe
+date: "2019-05-26"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0alpha1.
+
+This release works with PostgreSQL 9.5-12beta1 and GEOS >= 3.6
+
+Best served with PostgreSQL 12beta1.
+
+<!-- pagebreak -->
+
+**3.0.0alpha1**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0alpha1.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha1/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha1.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0alpha1.tar.gz)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha1.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0alpha1/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-- this next step repackages raster in its own extension
+-- and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-- New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/06-02_postgis-3.0.0alpha2.md b/content/post/2019/06-02_postgis-3.0.0alpha2.md
new file mode 100644
index 0000000..03155aa
--- /dev/null
+++ b/content/post/2019/06-02_postgis-3.0.0alpha2.md
@@ -0,0 +1,68 @@
+---
+title: PostGIS 3.0.0alpha2
+layout: post
+category: news
+tags: [release,3.0, 3.0.0alpha2]
+author: Regina Obe
+date: "2019-06-02"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0alpha2.
+
+This release works with PostgreSQL 9.5-12beta1 and GEOS >= 3.6
+
+Best served with PostgreSQL 12beta1.
+
+<!-- pagebreak -->
+
+**3.0.0alpha2**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0alpha2.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha2/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha2.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0alpha2.tar.gz)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha2.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0alpha2/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Changes since PostGIS 3.0.0alpha1 release are as follows:
+
+* 4404, [Fix selectivity issue with support functions (Paul Ramsey)](http://blog.cleverelephant.ca/2019/05/parallel-postgis-4.html)
+* 4311, Make wagyu the default option to validate polygons.
+ This option requires a C++11 compiler and will use CXXFLAGS (not CFLAGS).
+ It only enabled if built with MVT support (protobuf) and should speed up mvt tile generations
+ Add `--without-wagyu` to disable this option and keep the behaviour
+ from 2.5 (Raúl Marín)
+* 4198, Add [ST_ConstrainedDelaunayTriangles](/docs/manual-dev/ST_ConstrainedDelaunayTriangles.html) SFCGAL function (Darafei
+ Praliaskouski)
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-- this next step repackages raster in its own extension
+-- and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-- New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/07-01_postgis-3.0.0alpha3.md b/content/post/2019/07-01_postgis-3.0.0alpha3.md
new file mode 100644
index 0000000..9aadda4
--- /dev/null
+++ b/content/post/2019/07-01_postgis-3.0.0alpha3.md
@@ -0,0 +1,76 @@
+---
+title: PostGIS 3.0.0alpha3
+layout: post
+category: news
+tags: [release,3.0,3.0.0alpha3]
+author: Regina Obe
+date: "2019-07-01"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0alpha3.
+
+This release works with PostgreSQL 9.5-12beta2 and GEOS >= 3.6
+
+Best served with [PostgreSQL 12beta2](https://www.postgresql.org/developer/beta/).
+
+<!-- pagebreak -->
+
+**3.0.0alpha3**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0alpha3.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha3/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha3.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0alpha3.tar.gz)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha3.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0alpha3/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Main changes since PostGIS 3.0.0alpha2 release are as follows:
+
+* 4438, Update serialization to support extended flags area (Paul Ramsey)
+* 3437, Speed up ST_Intersects with Points (Raúl Marín)
+* 4352, Use CREATE OR REPLACE AGGREGATE for PG12+ (Raúl Marín)
+* 4441, Make GiST penalty friendly to multi-column indexes and build single-column
+ ones faster. (Darafei Praliaskouski)
+* 4372, PROJ6: Speed improvements (Raúl Marín)
+* 4414, Include version number in address_standardizer lib (Raúl Marín)
+* 4334, Fix upgrade issues related to renamed parameters (Raúl Marín)
+* 4388, AddRasterConstraints: Ignore NULLs when generating constraints (Raúl Marín)
+* 4327, Avoid pfree'ing the result of getenv (Raúl Marín)
+* 4406, Throw on invalid characters when decoding geohash (Raúl Marín)
+* 4429, Avoid resource leaks with PROJ6 (Raúl Marín)
+* 4443, Fix wagyu configure dropping CPPFLAGS (Raúl Marín)
+* 4440, Type lookups in FDW fail (Paul Ramsey)
+* 4442, raster2pgsql now skips NODATA tiles. Use -k option if you still want
+ them in database for some reason. (Darafei Praliaskouski)
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-- this next step repackages raster in its own extension
+-- and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-- New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/08-11_postgis-patches.md b/content/post/2019/08-11_postgis-patches.md
new file mode 100644
index 0000000..7fc9275
--- /dev/null
+++ b/content/post/2019/08-11_postgis-patches.md
@@ -0,0 +1,87 @@
+---
+title: PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 Released
+layout: post
+category: news
+tags: [release,3.0, 2.5,2.4,2.3,2.5.3,2.4.8,2.3.10]
+author: Regina Obe
+date: "2019-08-11"
+thumbnail: postgis.png
+---
+
+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.
+
+<!-- pagebreak -->
+**3.0.0alpha4**
+This release works with PostgreSQL 9.5-12beta3 and GEOS >= 3.6
+
+Best served with [PostgreSQL 12beta3](https://www.postgresql.org/developer/beta/).
+Designed to take advantage of features in PostgreSQL 12 and Proj 6
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0alpha4.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0alpha4/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha4.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0alpha4.tar.gz)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0alpha4.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0alpha4/ChangeLog)
+
+**2.5.3**
+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.
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.5.3.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.3/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.5.3.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-2.5.3-de.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.5.3.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.5) [de]({{< loc "site.root">}}docs/manual-2.5/postgis-de.html) [ja]({{< loc "site.root">}}docs/manual-2.5/postgis-ja.html)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.5.3.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.5.3/ChangeLog)
+
+**2.4.8**
+This release supports PostgreSQL 9.3-10.
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.4.8.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.8/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.4.8.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.4.8.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.4)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.4.8.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.4.8/ChangeLog)
+
+**2.3.10**
+
+This release supports PostgreSQL 9.2-10.
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-2.3.10.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.3.10/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.3.10.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.3.10.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-2.3)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.3.10.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/2.3.10/ChangeLog)
+
+
+View all [closed tickets for 3.0.0, 2.5.3, 2.4.8, 2.3.10][1].
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+```
+
+-- if you use the other extensions packaged with postgis
+-- make sure to upgrade those as well
+
+```postgres
+ALTER EXTENSION postgis_sfcgal UPDATE;
+ALTER EXTENSION postgis_topology UPDATE;
+ALTER EXTENSION postgis_tiger_geocoder UPDATE;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+2.3.10&milestone=PostGIS+2.4.8&milestone=PostGIS+2.5.3&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/09-28_postgis-3.0.0beta1.md b/content/post/2019/09-28_postgis-3.0.0beta1.md
new file mode 100644
index 0000000..0415845
--- /dev/null
+++ b/content/post/2019/09-28_postgis-3.0.0beta1.md
@@ -0,0 +1,75 @@
+---
+title: PostGIS 3.0.0beta1
+layout: post
+category: news
+tags: [release,3.0,3.0.0beta1]
+author: Regina Obe
+date: "2019-09-28"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0beta1.
+
+This release works with PostgreSQL 9.5-12RC1 and GEOS >= 3.6
+
+Best served with [PostgreSQL 12RC1](https://www.postgresql.org/developer/beta/)
+and [GEOS 3.8.0beta1](https://lists.osgeo.org/pipermail/geos-devel/2019-September/009267.html)
+both of which came out in the past couple of days.
+
+<!-- pagebreak -->
+
+**3.0.0beta1**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0beta1.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0beta1/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0beta1.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0beta1.tar.gz)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0beta1.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0beta1/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Main changes since PostGIS 3.0.0alpha4 release are as follows:
+
+* #4492, Fix ST_Simplify ignoring the value of the 3rd parameter (Raúl Marín)
+* #4494, Fix ST_Simplify output having an outdated bbox (Raúl Marín)
+* #4493, Fix ST_RemoveRepeatedPoints output having an outdated bbox (Raúl Marín)
+* #4495, Fix ST_SnapToGrid output having an outdated bbox (Raúl Marín)
+* #4496, Make ST_Simplify(TRIANGLE) collapse if requested (Raúl Marín)
+* #4501, Allow `postgis_tiger_geocoder` to be installable by non-super users (Regina Obe)
+* #4503, Speed up the calculation of cartesian bbox (Raúl Marín)
+* #4504, shp2pgsql -D not working with schema qualified tables (Regina Obe)
+* #4505, Speed up conversion of geometries to/from GEOS (Dan Baston)
+* #4507, Use GEOSMakeValid and GEOSBuildArea for GEOS 3.8+ (Dan Baston)
+* #4491, Speed up ST_RemoveRepeatedPoints (Raúl Marín)
+* #4509, Update geocoder for tiger 2019 (Regina Obe)
+* #4338, tiger geocoder Census block level data (tabblock table) not loading (Regina Obe)
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-* this next step repackages raster in its own extension
+-* and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-* New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/10-08_postgis-3.0.0rc1.md b/content/post/2019/10-08_postgis-3.0.0rc1.md
new file mode 100644
index 0000000..2572739
--- /dev/null
+++ b/content/post/2019/10-08_postgis-3.0.0rc1.md
@@ -0,0 +1,69 @@
+---
+title: PostGIS 3.0.0rc1
+layout: post
+category: news
+tags: [release,3.0,3.0.0rc1]
+author: Regina Obe
+date: "2019-10-08"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0rc1.
+
+This release works with PostgreSQL 9.5-12 and GEOS >= 3.6
+
+Best served with [PostgreSQL 12](https://www.postgresql.org/about/news/1976/)
+, [GEOS 3.8.0rc2](https://lists.osgeo.org/pipermail/geos-devel/2019-October/009288.html)
+and [pgRouting 3.0.0-alpha](https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-alpha).
+
+<!-- pagebreak -->
+
+**3.0.0rc1**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0rc1.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0rc1/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc1.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc1-de.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0rc1.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-dev), [de]({{< loc "site.root">}}docs/manual-dev/postgis-de.html), [ko_KR]({{< loc "site.root">}}docs/manual-dev/postgis-ko_KR.html), [ja]({{< loc "site.root">}}docs/manual-dev/postgis-ja.html)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc1.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0rc1/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Main changes since PostGIS 3.0.0beta1 release are as follows:
+
+* #4519, Fix getSRIDbySRS crash (Raúl Marín)
+* #4520, Use a clean environment when detecting C++ libraries (Raúl Marín)
+* Restore `ST_Union` aggregate signature so drop agg not required and re-work
+ performance/size enhancement to continue to avoid
+ using Array type during `ST_Union`, hopefully
+ avoiding Array size limitations. (Paul Ramsey)
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-* this next step repackages raster in its own extension
+-* and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-* New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/10-13_postgis-3.0.0rc2.md b/content/post/2019/10-13_postgis-3.0.0rc2.md
new file mode 100644
index 0000000..e1d686c
--- /dev/null
+++ b/content/post/2019/10-13_postgis-3.0.0rc2.md
@@ -0,0 +1,69 @@
+---
+title: PostGIS 3.0.0rc2
+layout: post
+category: news
+tags: [release,3.0,3.0.0rc2]
+author: Regina Obe
+date: "2019-10-13"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0rc2.
+This will be the final RC before release.
+
+This release works with PostgreSQL 9.5-12 and GEOS >= 3.6
+
+Best served with [PostgreSQL 12](https://www.postgresql.org/about/news/1976/)
+, [GEOS 3.8.0](https://lists.osgeo.org/pipermail/geos-devel/2019-October/009342.html)
+and [pgRouting 3.0.0-alpha](https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-alpha).
+
+
+<!-- pagebreak -->
+
+**3.0.0rc2**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0rc2.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0rc2/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc2.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc2-de.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0rc2.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-3.0), [de]({{< loc "site.root">}}docs/manual-3.0/postgis-de.html), [ko_KR]({{< loc "site.root">}}docs/manual-3.0/postgis-ko_KR.html), [ja]({{< loc "site.root">}}docs/manual-3.0/postgis-ja.html)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0rc2.epub)
+* [Changelog](https://svn.osgeo.org/postgis/tags/3.0.0rc2/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Main changes since PostGIS 3.0.0rc1 release are as follows:
+
+* 4534, Fix leak in lwcurvepoly_from_wkb_state (Raúl Marín)
+* 4536, Fix leak in lwcollection_from_wkb_state (Raúl Marín)
+* 4537, Fix leak in WKT collection parser (Raúl Marín)
+* 4535, WKB: Avoid buffer overflow (Raúl Marín)
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-* this next step repackages raster in its own extension
+-* and upgrades all your other related postgis extension
+SELECT PostGIS_Extensions_Upgrade();
+
+--if you don't use raster, you can do
+DROP EXTENSION postgis_raster;
+```
+
+-* New users
+```postgres
+CREATE EXTENSION postgis;
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2019/10-20_postgis-3.0.0.md b/content/post/2019/10-20_postgis-3.0.0.md
new file mode 100644
index 0000000..03ffe80
--- /dev/null
+++ b/content/post/2019/10-20_postgis-3.0.0.md
@@ -0,0 +1,200 @@
+---
+title: PostGIS 3.0.0
+layout: post
+category: news
+tags: [release,3.0, 3.0.0]
+author: Regina Obe
+date: "2019-10-20"
+thumbnail: postgis.png
+---
+
+The PostGIS development team is pleased to release PostGIS 3.0.0.
+
+This release works with PostgreSQL 9.5-12 and GEOS >= 3.6.
+
+If you are using postgis_sfcgal extension, you need to compile against SFCGAL 1.3.1 or higher.
+
+Best served with [PostgreSQL 12](https://www.postgresql.org/about/news/1976/)
+, [GEOS 3.8.0](https://lists.osgeo.org/pipermail/geos-devel/2019-October/009342.html)
+and [pgRouting 3.0.0-beta](https://github.com/pgRouting/pgrouting/releases/tag/v3.0.0-beta).
+
+<!-- pagebreak -->
+
+**3.0.0**
+
+* [source download]({{< loc "postgis.release_source">}}/postgis-3.0.0.tar.gz)
+* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0/NEWS)
+* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.0.0.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-3.0.0-de.pdf)
+* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.0.0.tar.gz)
+* html online [en]({{< loc "site.root">}}docs/manual-3.0), [de]({{< loc "site.root">}}docs/manual-3.0/postgis-de.html), [ko_KR]({{< loc "site.root">}}docs/manual-3.0/postgis-ko_KR.html), [ja]({{< loc "site.root">}}docs/manual-3.0/postgis-ja.html)
+* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.0.0.epub)
+* [Changelog](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0/ChangeLog)
+
+View all [closed tickets for 3.0.0][1].
+
+Note that a major change in 3.0 is that the raster functionality has been broken out as a separate extension.
+If you are upgrading from a previous edition, do the following:
+
+-- Upgrading
+
+After installing the binaries or after running pg_upgrade, make sure to do:
+
+```postgres
+ALTER EXTENSION postgis UPDATE;
+-- this next step repackages raster in its own extension
+-- and upgrades all your other related postgis extensions
+SELECT PostGIS_Extensions_Upgrade();
+
+-- if you don't use raster, you can do below
+-- after the upgrade step
+DROP EXTENSION postgis_raster;
+```
+
+-- Fresh install
+```postgres
+-- installs geometry and geography support
+CREATE EXTENSION postgis;
+-- install these if you need them
+CREATE EXTENSION postgis_raster;
+CREATE EXTENSION postgis_topology;
+-- 3d and advanced processing
+CREATE EXTENSION postgis_sfcgal;
+-- street address normalization
+CREATE EXTENSION address_standardizer;
+-- geocoder/reverse_geocoder for US census data
+CREATE EXTENSION postgis_tiger_geocoder CASCADE;
+```
+
+If you use legacy.sql or legacy_minimal.sql,
+make sure to rerun the version packaged with these releases.
+
+**Key Breaking Changes**
+
+* 3888, Raster support now in a separate extension - postgis_raster
+ (Sandro Santilli)
+* 3807, Extension library files no longer include the minor version.
+ If you need the old behavior,
+ use the new configure switch `--with-library-minor-version`.
+ This change is intended to smooth future pg_upgrade since lib file names
+ won't change between 3.0, 3.1, 3.* releases (Regina Obe)
+* 4230, ND box operators (overlaps, contains, within, equals) now don't look on
+ dimensions that aren't present in both operands.
+ Please REINDEX your ND indexes after upgrade. (Darafei Praliaskouski)
+
+* 4433, 32-bit hash fix (requires reindexing hash(geometry) indexes) (Raúl Marín)
+* 3383, Sorting now uses Hilbert curve and Postgres Abbreviated Compare.
+ You need to REINDEX your btree indexes if you had them.
+ (Darafei Praliaskouski)
+
+**New Features**
+
+* 2902, postgis_geos_noop (Sandro Santilli)
+* 4128, ST_AsMVT support for Feature ID (Stepan Kuzmin)
+* 4230, SP-GiST and GiST support for ND box operators overlaps, contains,
+ within, equals (Esteban Zimányi and Arthur Lesuisse from Université
+ Libre de Bruxelles (ULB), Darafei Praliaskouski)
+* 4171, ST_3DLineInterpolatePoint (Julien Cabieces, Vincent Mora)
+* 4311, Introduce WAGYU to validate MVT polygons. This option requires a C++11
+ compiler and will use CXXFLAGS (not CFLAGS). Add `--without-wagyu`
+ to disable this option and keep the behaviour from 2.5 (Raúl Marín)
+* 1833, ST_AsGeoJSON(row) generates full GeoJSON Features (Joe Conway)
+* 3687, Casts json(geometry) and jsonb(geometry) for implicit GeoJSON
+ generation (Paul Ramsey)
+* 4198, Add ST_ConstrainedDelaunayTriangles SFCGAL function (Darafei
+ Praliaskouski)
+
+**Enhancements**
+
+* 4341, Using "support function" API in PgSQL 12+ to replace SQL inlining
+as the mechanism for providing index support under ST_Intersects, et al
+* 4330, postgis_restore OOM when output piped to an intermediate process
+(Hugh Ranalli)
+* 4322, Support for Proj 6+ API, bringing more accurate datum transforms
+and support for WKT projections
+* 4153, ST_Segmentize now splits segments proportionally (Darafei
+Praliaskouski).
+* 4162, ST_DWithin documentation examples for storing geometry and
+radius in table (Darafei Praliaskouski, github user Boscop).
+* 4161 and #4294, ST_AsMVTGeom: Shortcut geometries smaller than the
+resolution (Raúl Marín)
+* 4176, ST_Intersects supports GEOMETRYCOLLECTION (Darafei Praliaskouski)
+* 4181, ST_AsMVTGeom: Avoid type changes due to validation (Raúl Marín)
+* 4183, ST_AsMVTGeom: Drop invalid geometries after simplification (Raúl Marín)
+* 4196, Have postgis_extensions_upgrade() package unpackaged extensions
+(Sandro Santilli)
+* 4215, Use floating point compare in ST_DumpAsPolygons (Darafei Praliaskouski)
+* 4155, Support for GEOMETRYCOLLECTION, POLYGON, TIN, TRIANGLE in
+ST_LocateBetween and ST_LocateBetweenElevations (Darafei Praliaskouski)
+* 2767, Documentation for AddRasterConstraint optional parameters (Sunveer Singh)
+* 4244, Avoid unaligned memory access in BOX2D_out (Raúl Marín)
+* 4139, Make mixed-dimension ND index build tree correctly (Darafei Praliaskouski,
+Arthur Lesuisse, Andrew Gierth, Raúl Marín)
+* 4262, Document MULTISURFACE compatibility of ST_LineToCurve (Steven Ottens)
+* 4276, ST_AsGeoJSON documentation refresh (Darafei Praliaskouski)
+* 4292, ST_AsMVT: parse JSON numeric values with decimals as doubles (Raúl Marín)
+* 4300, ST_AsMVTGeom: Always return the simplest geometry (Raúl Marín)
+* 4301, ST_Subdivide: fix endless loop on coordinates near coincident to bounds
+(Darafei Praliaskouski)
+* 4289, ST_AsMVTGeom: Transform coordinates space before clipping (Raúl Marín)
+* 4272, Improve notice message when unable to compute stats (Raúl Marín)
+* 4313, #4307, PostgreSQL 12 compatibility (Laurenz Albe, Raúl Marín)
+* 4299, #4304, ST_GeneratePoints is now VOLATILE. IMMUTABLE version with
+seed parameter added. (Mike Taves)
+* 4278, ST_3DDistance and ST_3DIntersects now support Solid TIN and Solid
+POLYHEDRALSURFACE (Darafei Praliaskouski)
+* 4348, ST_AsMVTGeom (GEOS): Enforce validation at all times (Raúl Marín)
+* 4295, Allow GEOMETRYCOLLECTION in ST_Overlaps, ST_Contains, ST_ContainsProperly,
+ST_Covers, ST_CoveredBy, ST_Crosses, ST_Touches, ST_Disjoint, ST_Relate,
+ST_Equals (Esteban Zimányi)
+* 4340, ST_Union aggregate now can handle more than 1 GB of geometries
+(Darafei Praliaskouski)
+* 4378, Allow passing TINs as input to GEOS-backed functions (Darafei
+Praliaskouski)
+* 4368, Reorder LWGEOM struct members to minimize extra padding (Raúl Marín)
+* 4141, Use uint64 to handle row counts in the topology extension (Raúl Marín)
+* 4225, Upgrade tiger to use tiger 2018 census files
+* 4412, Support ingesting rasters with NODATA=NaN (Darafei Praliaskouski)
+* 4413, Raster tile size follows GeoTIFF block size on raster2pgsql -t auto
+(Darafei Praliaskouski)
+* 4422, Modernize Python 2 code to get ready for Python 3 (Christian Clauss)
+* 4352, Use CREATE OR REPLACE AGGREGATE for PG12+ (Raúl Marín)
+* 4394, Allow FULL OUTER JOIN on geometry equality operator (Darafei Praliaskouski)
+* 4441, Make GiST penalty friendly to multi-column indexes and build single-column
+ones faster. (Darafei Praliaskouski)
+* 4403, Support for shp2pgsql ability to reproject with copy mode (-D) (Regina Obe)
+* 4410, More descriptive error messages about SRID mismatch (Darafei Praliaskouski)
+* 4399, TIN and Triangle output support in all output functions (Darafei
+Praliaskouski)
+* 3719, Impose minimum number of segments per arc during linearization
+(Dan Baston / City of Helsinki, Raúl Marín)
+* 4277, ST_GeomFromGeoJSON now marks SRID=4326 by default as per RFC7946,
+ST_AsGeoJSON sets SRID in JSON output if it differs from 4326.
+(Darafei Praliaskouski)
+* 3979, postgis_sfcgal_noop() round trip function (Lucas C. Villa Real)
+* 4328, ST_3DIntersects for 2D TINs. (Darafei Praliaskouski)
+* 4509, Update geocoder for tiger 2019 (Regina Obe)
+
+
+**Minor Breaking Changes**
+
+* 4267, Bump minimum GEOS version to 3.6 (Regina Obe, Darafei Praliaskouski)
+* 4229, Dropped support for PostgreSQL < 9.5. (Darafei Praliaskouski)
+* 4260, liblwgeom headers are not installed anymore.
+ If your project depends on them available, please use
+ librttopo instead. (Darafei Praliaskouski)
+* 4258, Remove SFCGAL support for `ST_Area`, `ST_Distance`, `ST_Intersection`,
+ `ST_Difference`, `ST_Union`, `ST_Intersects`, `ST_3DIntersects`, `ST_3DDistance`
+ and `postgis.backend` switch (Darafei Praliaskouski)
+* 4267, Enable Proj 6 deprecated APIs (Darafei Praliaskouski, Raúl Marín)
+* 4268, Bump minimum SFCGAL version to 1.3.1 (Darafei Praliaskouski)
+* 4331, ST_3DMakeBox now returns error instead of a miniscule box (Regina Obe)
+* 4342, Removed "versioned" variants of `ST_AsGeoJSON` and `ST_AsKML` (Paul Ramsey)
+* 4356, ST_Accum removed. Use array_agg instead. (Darafei Praliaskouski)
+* 4414, Include version number in address_standardizer lib (Raúl Marín)
+* 4334, Fix upgrade issues related to renamed function parameters (Raúl Marín)
+* 4442, raster2pgsql now skips NODATA tiles. Use -k option if you still want
+ them in database for some reason. (Darafei Praliaskouski)
+
+
+
+[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.0.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2020/08-15_postgis-patches.md b/content/post/2020/08-15_postgis-patches.md
index bc7eb60..1289fd1 100644
--- a/content/post/2020/08-15_postgis-patches.md
+++ b/content/post/2020/08-15_postgis-patches.md
@@ -34,7 +34,7 @@ advantage of features new in PostgreSQL 12.
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.5.5/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.5.5.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.5.5.tar.gz)
-* html online [en]({{ site.root }}docs/manual-2.5) [de]({{ site.root }}docs/manual-2.5/postgis-de.html) [ja]({{ site.root }}docs/manual-2.5/postgis-ja.html)
+* html online [en]({{< loc "site.root">}}docs/manual-2.5) [de]({{< loc "site.root">}}docs/manual-2.5/postgis-de.html) [ja]({{< loc "site.root">}}docs/manual-2.5/postgis-ja.html)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.5.5.epub)
**2.4.9**
@@ -44,7 +44,7 @@ This release supports PostgreSQL 9.3-10.
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/2.4.9/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-2.4.9.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-2.4.9.tar.gz)
-* html online [en]({{ site.root }}docs/manual-2.4)
+* html online [en]({{< loc "site.root">}}docs/manual-2.4)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-2.4.9.epub)
@@ -53,25 +53,25 @@ View all [closed tickets for 3.0.2, 2.5.5, 2.4.9][1].
After installing the binaries or after running pg_upgrade:
For PostGIS 2.5 and 3.0 do:
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
For PostGIS 2.4 do:
-{% geshi 'sql' %}
+```postgres
ALTER EXTENSION postgis UPDATE;
-{% endgeshi %}
+```
-- if you use the other extensions packaged with postgis
-- make sure to upgrade those as well
-{% geshi 'sql' %}
+```postgres
ALTER EXTENSION postgis_sfcgal UPDATE;
ALTER EXTENSION postgis_topology UPDATE;
ALTER EXTENSION postgis_tiger_geocoder UPDATE;
-{% endgeshi %}
+```
If you use legacy.sql or legacy_minimal.sql,
make sure to rerun the version packaged with these releases.
diff --git a/content/post/2021/09-04_postgis-patches.md b/content/post/2021/09-04_postgis-patches.md
index 9b30890..62f2c5a 100644
--- a/content/post/2021/09-04_postgis-patches.md
+++ b/content/post/2021/09-04_postgis-patches.md
@@ -20,7 +20,7 @@ This release supports PostgreSQL 9.6-14.
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.4/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.1.4.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.1.4.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.1)
+* html online [en]({{< loc "site.root">}}docs/manual-3.1)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.1.4.epub)
**3.0.4**
@@ -40,25 +40,25 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
do below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
For PostGIS 2.4 and below do:
-{% geshi 'sql' %}
+```postgres
ALTER EXTENSION postgis UPDATE;
-{% endgeshi %}
+```
-- if you use the other extensions packaged with postgis
-- make sure to upgrade those as well
-{% geshi 'sql' %}
+```postgres
ALTER EXTENSION postgis_sfcgal UPDATE;
ALTER EXTENSION postgis_topology UPDATE;
ALTER EXTENSION postgis_tiger_geocoder UPDATE;
-{% endgeshi %}
+```
If you use legacy.sql or legacy_minimal.sql,
make sure to rerun the version packaged with these releases.
diff --git a/content/post/2021/09-11_postgis-3.2.0alpha1.md b/content/post/2021/09-11_postgis-3.2.0alpha1.md
index 954df52..39fd1e1 100644
--- a/content/post/2021/09-11_postgis-3.2.0alpha1.md
+++ b/content/post/2021/09-11_postgis-3.2.0alpha1.md
@@ -22,7 +22,7 @@ This release supports PostgreSQL 9.6-14.
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0alpha1/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0alpha1.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0alpha1.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0alpha1.epub)
Details of this release can be found in NEWS file:
@@ -119,9 +119,9 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
do below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2021/10-23_postgis-3.2.0beta1.md b/content/post/2021/10-23_postgis-3.2.0beta1.md
index 7e745c0..2eaf596 100644
--- a/content/post/2021/10-23_postgis-3.2.0beta1.md
+++ b/content/post/2021/10-23_postgis-3.2.0beta1.md
@@ -22,7 +22,7 @@ This release supports PostgreSQL 9.6-14.
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0beta1/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta1.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0beta1.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta1.epub)
Details of this release can be found in NEWS file:
@@ -60,9 +60,9 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
do below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2021/11-26_postgis-3.2.0beta2.md b/content/post/2021/11-26_postgis-3.2.0beta2.md
index 4a2f17e..9cdce92 100644
--- a/content/post/2021/11-26_postgis-3.2.0beta2.md
+++ b/content/post/2021/11-26_postgis-3.2.0beta2.md
@@ -23,7 +23,7 @@ This release supports PostgreSQL 9.6-14, GEOS 3.6 and higher, and proj 4.9 and h
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0beta2/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta2.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0beta2.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta2.epub)
Details of this release can be found in NEWS file:
@@ -57,9 +57,9 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
do below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2021/12-04_postgis-3.2.0beta3.md b/content/post/2021/12-04_postgis-3.2.0beta3.md
index 45042aa..a70094c 100644
--- a/content/post/2021/12-04_postgis-3.2.0beta3.md
+++ b/content/post/2021/12-04_postgis-3.2.0beta3.md
@@ -23,7 +23,7 @@ This release supports PostgreSQL 9.6-14, GEOS 3.6 and higher, and proj 4.9 and h
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0beta3/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta3.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0beta3.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0beta3.epub)
Details of this release can be found in NEWS file:
@@ -43,19 +43,19 @@ as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);
-{% endgeshi %}
+```
To revert the change:
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
DROP FUNCTION 11 (geometry);
-{% endgeshi %}
+```
and then reindex your gist indexes.
@@ -76,9 +76,9 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
Do the below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2021/12-10_postgis-3.2.0rc1.md b/content/post/2021/12-10_postgis-3.2.0rc1.md
index 450c810..4a87bb3 100644
--- a/content/post/2021/12-10_postgis-3.2.0rc1.md
+++ b/content/post/2021/12-10_postgis-3.2.0rc1.md
@@ -23,7 +23,7 @@ This release supports PostgreSQL 9.6-14, GEOS 3.6 and higher, and proj 4.9 and h
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0rc1/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0rc1.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0rc1.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0rc1.epub)
Details of this release can be found in NEWS file:
@@ -41,19 +41,19 @@ as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);
-{% endgeshi %}
+```
To revert the change:
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
DROP FUNCTION 11 (geometry);
-{% endgeshi %}
+```
and then reindex your gist indexes.
@@ -63,9 +63,9 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0, 2.5
Do the below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
[1]: https://trac.osgeo.org/postgis/query?status=closed&resolution=fixed&milestone=PostGIS+3.2.0&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
diff --git a/content/post/2021/12-18_postgis-3.2.0.md b/content/post/2021/12-18_postgis-3.2.0.md
index d6c9762..823bd7d 100644
--- a/content/post/2021/12-18_postgis-3.2.0.md
+++ b/content/post/2021/12-18_postgis-3.2.0.md
@@ -31,7 +31,7 @@ This release supports PostgreSQL 9.6-14, GEOS 3.6 and higher, and proj 4.9 and h
* [NEWS](https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.2.0/NEWS)
* PDF docs [en]({{< loc "postgis.release_docs">}}/postgis-3.2.0.pdf) [de]({{< loc "postgis.release_docs">}}/postgis-3.2.0-de.pdf)
* [html doc download]({{< loc "postgis.release_docs">}}/doc-html-3.2.0.tar.gz)
-* html online [en]({{ site.root }}docs/manual-3.2/) [de]({{ site.root }}docs/manual-3.2/postgis-de.html) [ja]({{ site.root }}docs/manual-3.2/postgis-ja.html) [ko_KR]({{ site.root }}docs/manual-3.2/postgis-ko_KR.html)
+* html online [en]({{< loc "site.root">}}docs/manual-3.2/) [de]({{< loc "site.root">}}docs/manual-3.2/postgis-de.html) [ja]({{< loc "site.root">}}docs/manual-3.2/postgis-ja.html) [ko_KR]({{< loc "site.root">}}docs/manual-3.2/postgis-ko_KR.html)
* [epub doc download]({{< loc "postgis.release_docs">}}/postgis-3.2.0.epub)
Details of this release can be found in NEWS file:
@@ -49,19 +49,19 @@ as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
ADD FUNCTION 11 (geometry)
geometry_gist_sortsupport_2d (internal);
-{% endgeshi %}
+```
To revert the change:
-{% geshi 'sql' %}
+```postgres
ALTER OPERATOR FAMILY gist_geometry_ops_2d
USING gist
DROP FUNCTION 11 (geometry);
-{% endgeshi %}
+```
and then reindex your gist indexes.
diff --git a/content/post/2022/02-01_postgis-3.1.5.md b/content/post/2022/02-01_postgis-3.1.5.md
index 38da5b0..df08449 100644
--- a/content/post/2022/02-01_postgis-3.1.5.md
+++ b/content/post/2022/02-01_postgis-3.1.5.md
@@ -41,18 +41,18 @@ After installing the binaries or after running pg_upgrade:
For PostGIS 3.1, 3.0
do below which will upgrade all your postgis extensions.
-{% geshi 'sql' %}
+```postgres
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
For PostGIS 2.5 and below do:
-{% geshi 'sql' %}
+```postgres
ALTER EXTENSION postgis UPDATE;
SELECT postgis_extensions_upgrade();
SELECT postgis_extensions_upgrade();
-{% endgeshi %}
+```
If you come across any issues, feel free to report via our [ticket tracker](https://trac.osgeo.org/postgis)
or [mailing list](https://lists.osgeo.org/listinfo/postgis-users) with details
diff --git a/layouts/shortcodes/loc.html b/layouts/shortcodes/loc.html
index 6c5093f..cf2f4dd 100644
--- a/layouts/shortcodes/loc.html
+++ b/layouts/shortcodes/loc.html
@@ -7,4 +7,5 @@
{{ site.Params.postgis.release_source}}{{- print "" -}}
{{- end }}
{{- if eq $var "postgis.release_notes" }}{{ site.Params.postgis.release_notes}}{{- print "" -}}{{- end }}
+{{- if eq $var "site.root" }}{{ site.BaseURL}}{{- print "" -}}{{- end }}
-----------------------------------------------------------------------
Summary of changes:
content/pages/windows_downloads.md | 8 +-
content/post/2019/03-11_postgis-patches.md | 77 ++++++++++
content/post/2019/05-26_postgis-3.0.0alpha1.md | 57 +++++++
content/post/2019/06-02_postgis-3.0.0alpha2.md | 68 +++++++++
content/post/2019/07-01_postgis-3.0.0alpha3.md | 76 ++++++++++
content/post/2019/08-11_postgis-patches.md | 87 +++++++++++
content/post/2019/09-28_postgis-3.0.0beta1.md | 75 ++++++++++
content/post/2019/10-08_postgis-3.0.0rc1.md | 69 +++++++++
content/post/2019/10-13_postgis-3.0.0rc2.md | 69 +++++++++
content/post/2019/10-20_postgis-3.0.0.md | 200 +++++++++++++++++++++++++
content/post/2020/08-15_postgis-patches.md | 16 +-
content/post/2021/09-04_postgis-patches.md | 14 +-
content/post/2021/09-11_postgis-3.2.0alpha1.md | 6 +-
content/post/2021/10-23_postgis-3.2.0beta1.md | 6 +-
content/post/2021/11-26_postgis-3.2.0beta2.md | 6 +-
content/post/2021/12-04_postgis-3.2.0beta3.md | 14 +-
content/post/2021/12-10_postgis-3.2.0rc1.md | 14 +-
content/post/2021/12-18_postgis-3.2.0.md | 10 +-
content/post/2022/02-01_postgis-3.1.5.md | 8 +-
layouts/shortcodes/loc.html | 1 +
20 files changed, 830 insertions(+), 51 deletions(-)
create mode 100644 content/post/2019/03-11_postgis-patches.md
create mode 100644 content/post/2019/05-26_postgis-3.0.0alpha1.md
create mode 100644 content/post/2019/06-02_postgis-3.0.0alpha2.md
create mode 100644 content/post/2019/07-01_postgis-3.0.0alpha3.md
create mode 100644 content/post/2019/08-11_postgis-patches.md
create mode 100644 content/post/2019/09-28_postgis-3.0.0beta1.md
create mode 100644 content/post/2019/10-08_postgis-3.0.0rc1.md
create mode 100644 content/post/2019/10-13_postgis-3.0.0rc2.md
create mode 100644 content/post/2019/10-20_postgis-3.0.0.md
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list