[postgis-tickets] [SCM] postgis.net branch website-pr updated. 625f40399003cf444dfb2f68adb3990236275c82
git at osgeo.org
git at osgeo.org
Tue May 9 17:25:14 PDT 2023
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, website-pr has been updated
via 625f40399003cf444dfb2f68adb3990236275c82 (commit)
from bfb146ba3d6c5c3e00e3cebe88b71851c8539cf3 (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 625f40399003cf444dfb2f68adb3990236275c82
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date: Tue May 9 17:25:07 2023 -0700
binary pages
diff --git a/content/documentation/getting_started/install_windows.md b/content/documentation/getting_started/install_windows.md
deleted file mode 100644
index dfd9c05..0000000
--- a/content/documentation/getting_started/install_windows.md
+++ /dev/null
@@ -1,147 +0,0 @@
----
-title: Installing on Windows
-date: 2022-02-01
-description: PostGIS windows binaries for both 32-bit and 64-bit windows
-weight: 100
-geekdocHidden: true
-geekdocHiddenTocTree: false
----
-
-If you need help using these packages (the installers and buildbot binaries), please ask on our [users mailing list](https://lists.osgeo.org/mailman/listinfo/postgis-users).
-
-If you find a bug with the installers or the buildbot packages, please report these on our [Ticket Tracker](/support) under component: build/upgrade/install with keyword: windows.
-
-
-***The installers are designed to work with [EnterpriseDb PostgreSQL distributions](https://www.postgresql.org/download/windows/).***
-
-# Released Versions
-
-PostGIS 3.3.2 came out Nov 13, 2022. Windows PostGIS Bundle 3.3.2 was originally released Nov 21st, 2022 and rereleased on Dec 2nd, 2022.
-
-The rerelease includes updated pgRouting updated to 3.4.2 and a [fix for packaging issue of raster2pgsql](https://trac.osgeo.org/postgis/ticket/5292).
-
-There was also an issue with the PostgreSQL 13 which made it inaccessible from application stackbuilder.
-
-Binaries for versions of PostgreSQL 11-15 (64-bit) available in `Unreleased PostGIS Versions` and [OSGeo downloads][5]). Installers for 11-15(64-bit) are available on stackbuilder and [OSGeo downloads][5].
-
-New feature in this release is [h3-pg](https://github.com/zachasme/h3-pg) which includes `h3` and `h3_postgis` extensions for utilizing Uber's Hexagon indexing system within PostgreSQL.
-
-If you are using PostgreSQL < 11, use the PostGIS 3.2.3 bundle, because PostGIS 3.3+ does not support those versions.
-
-PostGIS 3.3.2 bundle includes:
-
- * PostGIS 3.3.2 with MVT support, with raster, [GEOS](https://libgeos.org/posts/2022-11-14-geos-3-11-1-released/) 3.11.1, [PROJ](https://proj.org/download.html#past-releases) 7.2.1, [SFCGAL](http://sfcgal.org) support (1.4.1), address_standardizer, topology
- * PostGIS Tiger geocoder extension - Tiger 2022
- * pgRouting 3.4 [pgRouting 3.4.2](https://docs.pgrouting.org/3.4/en/index.html)
- * Commandline raster loader (raster2pgsql), shapefile import/export (shp2pgsql,pgsql2shp)
- * Commandline [osm2pgrouting 2.3.8](https://github.com/pgRouting/osm2pgrouting/wiki/Documentation-for-osm2pgrouting-v2.3) for loading data from .osm files into pgRouting routable format
- * GUI: shp2pgsql-gui which has both import and export support for geometry/geography
- * [ogrfdw 1.1.3](https://github.com/pramsey/pgsql-ogr-fdw/releases/tag/v1.1.3) - spatial foreign data wrapper for
- reading both spatial (spatial columns become postgis geometry) and non-spatial data. [IMPORT FOREIGN SCHEMA](http://www.postgresonline.com/journal/archives/359-Import-Foreign-Schema-for-ogr_fdw-for-PostgreSQL-9.5.html) support
- New features in 1.1 - `character_encoding` option and utility functions `ogr_fdw_drivers()`, `ogr_fdw_version()`
-
- * [GDAL 3.4.3](https://gdal.org/download.html#current-releases) with OpenJPEG 2.4.0 (JPEG 2000), ODBC, Curl, SQLite3 (for GeoPackage and OSM support), excel (XLS) (via FreeXL 1.0.6), libreoffice, XLSX spreadsheet (via expat) (used by both PostGIS raster and ogrfdw)
- * [pgpointcloud](https://github.com/pgpointcloud/pointcloud) 1.2.4
- for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry
- * [h3-pg](https://github.com/zachasme/h3-pg) 4.0.3 - this is the first PostGIS Bundle to include this feature
- for using Uber h3 api and converting h3 index representations to postgis geometry/geography.
-
-The simplest way to get PostGIS on Windows for the EnterpriseDb Windows PostgreSQL distribution is using the StackBuilder.
-
-Refer to [An Almost Idiot's Guide Installing PostGIS on Windows][4]
-
- 1. Download and install PostgreSQL [from EnterpriseDB](https://www.postgresql.org/download/windows/).
- 2. Run the "StackBuilder" utility and install the PostGIS add-on.
-
-If you want to use the zip, setup, and setup source files directly
-they are available:
-
-* [Zip and Installer files][5] The .zip files are just the binaries you can copy into
- your PostgreSQL installation and then enable in each database as usual. The exe are standard windows setup for 64-bit PostgreSQL.
-* [Source Setup files][6] The source setup files are useful if you want to build your own [NSIS installer][7] or create a single setup for your own project that also installs PostGIS. The [Binary zip files][5] should contain all the binary files you need to customize your own setup minus the documentation. You can also just extract the .exe setup file to get the binaries, but the extract sometimes gets mangled leaving out some of the postgis-gui subfolders.
-
-[4]: https://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
-[5]: https://download.osgeo.org/postgis/windows
-[6]: https://download.osgeo.org/postgis/windows/source
-[7]: http://nsis.sourceforge.net/Download
-
-
-## Unreleased PostGIS Versions
-
-If you are more adventurous, and risk-seeking you can partake in our experimental windows
-binaries of PostGIS built automatically by Winnie whenever there is a change in any of the PostGIS Stable or development branches. These are especially useful for testing out new features or if you are badly in need of a bug fix that has not been released yet.
-
-If you don't want to risk messing up an existing windows install or aren't allowed to write to the registry, we'd suggest using the companion [PostgreSQL EDB binaries-only][8] binaries which don't require installation. Setup is detailed in [Starting PostgreSQL in windows without install](http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html).
-
-## Windows: Winnie Bot PostGIS and pgRouting Experimental Builds
-
-* [for PostgreSQL 32-bit/64-bit][1]
-
-### Installing Experimental Binaries
-
-* Copy the contents of the respective folders in the zip file to your PostgreSQL install and when prompted to overwrite, overwrite
-* The newer GEOS will work with older PostGIS installs, but newest PostGIS will only work with the newer GEOS.
-
-
-## Enabling PostGIS
-
-PostGIS and other extensions are optional extensions that must be enabled in EVERY database you want to use them in.
-
-```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+
-CREATE EXTENSION postgis_raster;
-
-CREATE EXTENSION postgis_sfcgal;
-CREATE EXTENSION address_standardizer;
-CREATE EXTENSION fuzzystrmatch;
-CREATE EXTENSION postgis_topology;
-CREATE EXTENSION postgis_tiger_geocoder;
-```
-
-### PostGIS related extensions
-
-These extensions are part of the PostGIS bundle, but you can also download the latest separately.
-
-If you want to use pgrouting, download the respective one for your PostgreSQL/
-
-```postgres
-CREATE EXTENSION pgrouting;
-```
-
-For loading OpenStreetMap data (OSM) into pgrouting format, you can use osm2po or [osm2pgrouting][10]. Windows binaries for osm2pgrouting can be found alongside pgrouting for each version. Refer to instructions in the zip. Make sure to use the 32-bit with 32-bit PostgreSQL install and 64-bit for PostgreSQL 64-bit install (copying the .dlls into your respective PostgreSQL/bin folder).
-
-Additional extensions included in the PostGIS Bundle, that are not part of PostGIS project
-are the following. These ones you'll find in the `extras` folder if you want to use not yet released versions.
-
-```postgres
--- for querying external spatial
--- and non-spatial data sources
-CREATE EXTENSION ogr_fdw;
-
--- for managing pointcloud data
-CREATE EXTENSION pointcloud;
-CREATE EXTENSION pointcloud_postgis;
-
--- for using Uber h3 indexing scheme
-CREATE EXTENSION h3;
-CREATE EXTENSION h3_postgis;
-```
-
-See the [Getting Started]({{< ref "/documentation/getting_started/" >}}) section for more guidance.
-
-
-[1]: https://winnie.postgis.net/download/windows/
-[2]: https://winnie.postgis.net/download/windows/pg91/buildbot/
-[3]: https://winnie.postgis.net/download/windows/pg90/buildbot/
-[4]: https://winnie.postgis.net/download/windows/pg93/buildbot/
-[8]: https://www.enterprisedb.com/products-services-training/pgbindownload
-[9]: https://winnie.postgis.net/download/windows/pg94/buildbot/
-[10]: http://pgrouting.org/docs/tools/osm2pgrouting.html
-[11]: https://winnie.postgis.net/download/windows/pg94/buildbot/extras
-[12]: https://winnie.postgis.net/download/windows/pg95/buildbot/
-[13]: https://winnie.postgis.net/download/windows/pg96/buildbot/
-[14]: https://winnie.postgis.net/download/windows/pg10/buildbot/
-[15]: https://winnie.postgis.net/download/windows/pg11/buildbot/
-[16]: https://winnie.postgis.net/download/windows/pg12/buildbot/
diff --git a/content/documentation/getting_started/install_windows/_index.md b/content/documentation/getting_started/install_windows/_index.md
new file mode 100644
index 0000000..ab0be06
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/_index.md
@@ -0,0 +1,15 @@
+---
+title: Windows Builds
+date: 2022-02-01
+weight: 120
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+If you need help using these packages (the installers and buildbot binaries), please ask on the [postgis-users](https://lists.osgeo.org/mailman/listinfo/postgis-users) mailing list.
+
+If you find a bug with the installers or the buildbot packages, please report these on our [Ticket Tracker](/support) under component: build/upgrade/install with keyword: windows.
+
+***The installers are designed to work with [EnterpriseDb PostgreSQL distributions](https://www.postgresql.org/download/windows/).***
+
+{{< toc-tree >}}
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/01-04_win-pgrouting-2-4_branch.md b/content/documentation/getting_started/install_windows/ci/01-04_win-pgrouting-2-4_branch.md
new file mode 100644
index 0000000..b117a42
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/01-04_win-pgrouting-2-4_branch.md
@@ -0,0 +1,62 @@
+---
+title: pgRouting 2.4.1 Windows binaries
+
+pr_major_version: 2
+pr_minor_version: 4
+pr_micro_version: 3dev
+branch: 2.4
+buildbot: [pre_release_win_bin,pgrouting_2.4]
+series: windows_prelease
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+**pgRouting Package 2.4.3dev**
+
+For 10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 9.5(32-bit / 64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit), 9.2 (32-bit / 64-bit)
+refer to <a href="http://docs.pgrouting.org/2.4/en/pgRouting-concepts.html#getting-started" target="_blank">getting started guide</a> for more details.
+
+Also find in same folder companion osm2pgrouting-2.2.0 package for loading osm data.
+
+Will work with PostGIS 2.1-2.4 (not tested on PostGIS 2.0, but should work)
+
+ * <a href="http://docs.pgrouting.org/2.4/en/release_notes.html#changelog-2-4-1" target="_blank">pgRouting 2.4.1 release notes</a>
+ * compiled with CGAL 4.6
+ * compiled with boost 1.59.0
+ * PostgreSQL Extension files included
+
+ New Features since 2.3 release
+New Signatures
+
+ * pgr_bdDijkstra
+
+New Proposed Signatures
+
+ * pgr_maxFlow
+ * pgr_astar(one to many)
+ * pgr_astar(many to one)
+ * pgr_astar(many to many)
+ * pgr_astarCost(one to one)
+ * pgr_astarCost(one to many)
+ * pgr_astarCost(many to one)
+ * pgr_astarCost(many to many)
+ * pgr_astarCostMatrix
+
+Deprecated Signatures
+
+ * pgr_bddijkstra - use pgr_bdDijkstra instead
+
+Deprecated Functions
+
+ * pgr_pointsToVids
+
+Bug fix
+
+ * Bug fixes on proposed functions
+ pgr_withPointsKSP: fixed ordering
+ * TRSP original code is used with no changes on the compilation warnings
+
+
+ Improvements and consolidation of existing algorithms
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/01-05_win-pgrouting-2-5_branch.md b/content/documentation/getting_started/install_windows/ci/01-05_win-pgrouting-2-5_branch.md
new file mode 100644
index 0000000..ca2e34e
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/01-05_win-pgrouting-2-5_branch.md
@@ -0,0 +1,28 @@
+---
+title: pgRouting 2.5 Windows binaries
+
+pr_major_version: 2
+pr_minor_version: 5
+pr_micro_version: 2
+branch: 2.5
+buildbot: [pre_release_win_bin, pgrouting_2.5]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+**pgRouting Package 2.5.2**
+
+For 10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 9.5(32-bit / 64-bit), 9.4 (32-bit / 64-bit), 9.3 (32-bit /64-bit)
+refer to <a href="http://docs.pgrouting.org/2.5/en/pgRouting-concepts.html#getting-started" target="_blank">getting started guide</a> for more details.
+
+Also find in same folder companion osm2pgrouting-2.2.0 package for loading osm data.
+
+Will work with PostGIS 2.1-2.5 (not tested on PostGIS 2.0, but should work)
+
+ * <a href="http://docs.pgrouting.org/2.5/en/release_notes.html#changelog-2-5-2" target="_blank">pgRouting 2.5.2 release notes</a>
+ * compiled with CGAL 4.6
+ * compiled with boost 1.59.0
+ * PostgreSQL Extension files included
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-2-6_branch.md b/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-2-6_branch.md
new file mode 100644
index 0000000..75e7e3a
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-2-6_branch.md
@@ -0,0 +1,28 @@
+---
+title: pgRouting 2.6 Windows binaries
+
+pr_major_version: 2
+pr_minor_version: 6
+pr_micro_version: 1
+branch: 2.6
+buildbot: [pre_release_win_bin, pgrouting_2.6]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+**pgRouting Package 2.6.2**
+
+For 9.5-10 (32-bit / 64-bit), 9.6 (32-bit / 64-bit), 11 (64-bit)
+refer to <a href="https://docs.pgrouting.org/2.6/en/pgRouting-concepts.html#getting-started" target="_blank">getting started guide</a> for more details.
+
+Also find in same folder companion osm2pgrouting-2.2.0 package for loading osm data.
+
+Will work with PostGIS 2.1-3.0 (not tested on PostGIS 2.0, but should work)
+
+ * <a href="https://docs.pgrouting.org/2.6/en/release_notes.html#changelog-2-6-2" target="_blank">pgRouting 2.6.2 release notes</a>
+ * compiled with CGAL 4.11
+ * compiled with boost 1.59.0
+ * PostgreSQL Extension files included
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-3-0_branch.md b/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-3-0_branch.md
new file mode 100644
index 0000000..9374dd0
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-3-0_branch.md
@@ -0,0 +1,27 @@
+---
+title: pgRouting 3.0 Windows binaries
+
+pr_major_version: 3
+pr_minor_version: 0
+pr_micro_version: 0
+branch: 3.0
+buildbot: [pre_release_win_bin, pgrouting_3.0]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+**pgRouting Package 3.0.0**
+
+For 9.6-13 (64-bit)
+refer to <a href="https://docs.pgrouting.org/3.0/en/pgRouting-concepts.html#getting-started" target="_blank">getting started guide</a> for more details.
+
+Also find in same folder companion osm2pgrouting-2.3.6 package for loading osm data.
+
+Will work with PostGIS 2.5-3.1
+
+ * <a href="https://docs.pgrouting.org/2.6/en/release_notes.html#changelog-3-0-0" target="_blank">pgRouting 3.0.0 release notes</a>
+ * compiled with boost 1.59.0
+ * PostgreSQL Extension files included
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-04_win-postgis-2-3_branch.md b/content/documentation/getting_started/install_windows/ci/04-04_win-postgis-2-3_branch.md
new file mode 100644
index 0000000..1dec436
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-04_win-postgis-2-3_branch.md
@@ -0,0 +1,25 @@
+---
+title: PostGIS 2.3 Windows binaries
+
+major_version: 2
+minor_version: 3
+micro_version: 11dev
+revision: r
+branch: 2.3
+buildbot: [pre_release_win_bin, postgis_2.3]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+<a href='https://winnie.postgis.net/job/PostGIS_2.3/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_2.3'></a>
+**Packaged**
+
+ * GEOS 3.6.2, GDAL 2.2.4(with SQLite, ODBC, JPEG2000 via OpenJPEG 2.1, and Curl support), Proj 4.9.1, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2016 loader) + extension files
+ * address_standardizer extension
+ * PostgreSQL 9.6 (32/64-bit), PostgreSQL 9.5 (32/64-bit), 9.4 (32/64 bit), 9.3 (32/64 bit) built with SFCGAL 1.3+ support
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-05_win-postgis-2-4_branch.md b/content/documentation/getting_started/install_windows/ci/04-05_win-postgis-2-4_branch.md
new file mode 100644
index 0000000..5017742
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-05_win-postgis-2-4_branch.md
@@ -0,0 +1,27 @@
+---
+title: PostGIS 2.4.2dev Windows binaries
+
+major_version: 2
+minor_version: 4
+micro_version: 9dev
+revision:
+branch: 2.4
+buildbot: [pre_release_win_bin, postgis_2.4]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+<a href='https://winnie.postgis.net/job/PostGIS_2.4/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_2.4'></a>
+**Packaged**
+
+ * GEOS 3.7.0, GDAL 2.2.4 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG 2.2.0, and Curl support), Proj 4.9.3, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2017 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.3.2 support
+ * PROTOBUF-c 1.2.1 support
+ * PostgreSQL 10 (64-bit, 32-bit), PostgreSQL 9.6 (32/64-bit), PostgreSQL 9.5 (32/64-bit), 9.4 (32/64 bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-06_win-postgis-2-5_branch.md b/content/documentation/getting_started/install_windows/ci/04-06_win-postgis-2-5_branch.md
new file mode 100644
index 0000000..b4c3e16
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-06_win-postgis-2-5_branch.md
@@ -0,0 +1,27 @@
+---
+title: PostGIS 2.5.0dev Windows binaries
+
+major_version: 2
+minor_version: 5
+micro_version: 4dev
+revision:
+branch: 2.5
+tags: [pre_release_win_bin, postgis_2.5]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+<a href='https://winnie.postgis.net/job/PostGIS_2.5/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_2.5'></a>
+**Packaged**
+
+ * GEOS 3.7.2, GDAL 2.2.4 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG 2.2.0, and Curl support), Proj 4.9.3, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2017 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.3.2 support
+ * PROTOBUF-c 1.2.1 support
+ * PostgreSQL 11 (64-bit), PostgreSQL 10 (64-bit, 32-bit), PostgreSQL 9.6 (32/64-bit), PostgreSQL 9.5 (32/64-bit), 9.4 (32/64 bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-0_branch.md b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-0_branch.md
new file mode 100644
index 0000000..f994b20
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-0_branch.md
@@ -0,0 +1,27 @@
+---
+title: PostGIS 3.0.1dev Windows binaries
+
+major_version: 3
+minor_version: 0
+micro_version: 5dev
+revision:
+branch: 3.0
+buildbot: [pre_release_win_bin, postgis_3.0]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+<a href='https://winnie.postgis.net/job/PostGIS_3.0/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_3.0'></a>
+**Packaged**
+
+ * GEOS 3.9dev, GDAL 3.2.3 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG 2.2.0, and Curl support), Proj 7.1.1, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2019 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.3.8+ support
+ * PROTOBUF-c 1.2.1 + Wagyu support for MVT functions
+ * PostgreSQL 12 (64-bit), PostgreSQL 11 (64-bit), PostgreSQL 10 (64-bit), PostgreSQL 9.6 (64-bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-1_branch.md b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-1_branch.md
new file mode 100644
index 0000000..db96096
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-1_branch.md
@@ -0,0 +1,27 @@
+---
+title: PostGIS 3.1.2dev Windows binaries
+
+major_version: 3
+minor_version: 1
+micro_version: 5dev
+revision:
+branch: 3.1
+buildbot: [pre_release_win_bin, postgis_3.1]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+
+---
+<a href='https://winnie.postgis.net/job/PostGIS_3.1/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_3.1'></a>
+**Packaged**
+
+ * GEOS 3.9dev, GDAL 3.2.3 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG 2.2.0, and Curl support), Proj 7.1.1, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2020 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.3.9 support
+ * PROTOBUF-c 1.2.1 + Wagyu support for MVT functions
+ * PostgreSQL 13 (64-bit), PostgreSQL 12 (64-bit), PostgreSQL 11 (64-bit), PostgreSQL 10 (64-bit), PostgreSQL 9.6 (64-bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-2_branch.md b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-2_branch.md
new file mode 100644
index 0000000..ea609c9
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-2_branch.md
@@ -0,0 +1,26 @@
+---
+title: PostGIS 3.2 dev Windows binaries
+
+major_version: 3
+minor_version: 2
+micro_version: 4dev
+revision:
+branch: 3.2
+tags: [pre_release_win_bin, postgis_3.2]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+<a href='https://winnie.postgis.net/job/PostGIS_3.2/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_3.2'></a>
+**Packaged**
+
+ * GEOS 3.10, GDAL 3.4.3 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG, and Curl support), Proj 7.2.1, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2019 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.4.0 support
+ * PROTOBUF-c 1.2.1 + Wagyu support for MVT functions
+ * PostgreSQL 15 (64-bit) PostgreSQL 14 (64-bit) PostgreSQL 13 (64-bit), PostgreSQL 12 (64-bit), PostgreSQL 11 (64-bit), PostgreSQL 10 (64-bit), PostgreSQL 9.6 (64-bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-3_branch.md b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-3_branch.md
new file mode 100644
index 0000000..6b05677
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-3_branch.md
@@ -0,0 +1,26 @@
+---
+title: PostGIS 3.3.0dev Windows binaries
+
+major_version: 3
+minor_version: 3
+micro_version: 0dev
+revision:
+branch: 3.3
+buildbot: [pre_release_win_bin, postgis_3.3]
+author: Winnie
+thumbnail:
+
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+<a href='https://winnie.postgis.net/job/PostGIS_trunk/'><img src='https://winnie.postgis.net/buildStatus/icon?job=PostGIS_trunk'></a>
+**Packaged**
+
+ * GEOS 3.11, GDAL 3.4.3 (with SQLite3, FreeXL, Expat, ODBC, JPEG2000 via OpenJPEG, and Curl support), Proj 7.12.1, JSON 0.12
+ * raster2pgsql raster loader
+ * GUI and Commandline loader/exporters
+ * Tiger Geocoder (2019 loader) + extension files
+ * address_standardizer extension
+ * SFCGAL 1.4.1 support
+ * PROTOBUF-c 1.2.1 + Wagyu support for MVT functions
+ * PostgreSQL 15 (64-bit) PostgreSQL 14 (64-bit) PostgreSQL 13 (64-bit), PostgreSQL 12 (64-bit), PostgreSQL 11 (64-bit)
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/ci/_index.md b/content/documentation/getting_started/install_windows/ci/_index.md
new file mode 100644
index 0000000..a66bffc
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/ci/_index.md
@@ -0,0 +1,9 @@
+---
+title: Windows Binaries
+date: 2022-02-01
+weight: 40
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+{{< toc-tree >}}
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/enabling_postgis.md b/content/documentation/getting_started/install_windows/enabling_postgis.md
new file mode 100644
index 0000000..bc06ec9
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/enabling_postgis.md
@@ -0,0 +1,68 @@
+---
+title: Enabling PostGIS
+date: 2022-02-01
+weight: 30
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+PostGIS and other extensions are optional extensions that must be enabled in EVERY database you want to use them in.
+
+```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+
+CREATE EXTENSION postgis_raster;
+
+CREATE EXTENSION postgis_sfcgal;
+CREATE EXTENSION address_standardizer;
+CREATE EXTENSION fuzzystrmatch;
+CREATE EXTENSION postgis_topology;
+CREATE EXTENSION postgis_tiger_geocoder;
+```
+
+### PostGIS related extensions
+
+These extensions are part of the PostGIS bundle, but you can also download the latest separately.
+
+If you want to use pgrouting, download the respective one for your PostgreSQL/
+
+```postgres
+CREATE EXTENSION pgrouting;
+```
+
+For loading OpenStreetMap data (OSM) into pgrouting format, you can use osm2po or [osm2pgrouting][10]. Windows binaries for osm2pgrouting can be found alongside pgrouting for each version. Refer to instructions in the zip. Make sure to use the 32-bit with 32-bit PostgreSQL install and 64-bit for PostgreSQL 64-bit install (copying the .dlls into your respective PostgreSQL/bin folder).
+
+Additional extensions included in the PostGIS Bundle, that are not part of PostGIS project
+are the following. These ones you'll find in the `extras` folder if you want to use not yet released versions.
+
+```postgres
+-- for querying external spatial
+-- and non-spatial data sources
+CREATE EXTENSION ogr_fdw;
+
+-- for managing pointcloud data
+CREATE EXTENSION pointcloud;
+CREATE EXTENSION pointcloud_postgis;
+
+-- for using Uber h3 indexing scheme
+CREATE EXTENSION h3;
+CREATE EXTENSION h3_postgis;
+```
+
+See the [Getting Started]({{< ref "/documentation/getting_started/" >}}) section for more guidance.
+
+
+[1]: https://winnie.postgis.net/download/windows/
+[2]: https://winnie.postgis.net/download/windows/pg91/buildbot/
+[3]: https://winnie.postgis.net/download/windows/pg90/buildbot/
+[4]: https://winnie.postgis.net/download/windows/pg93/buildbot/
+[8]: https://www.enterprisedb.com/products-services-training/pgbindownload
+[9]: https://winnie.postgis.net/download/windows/pg94/buildbot/
+[10]: http://pgrouting.org/docs/tools/osm2pgrouting.html
+[11]: https://winnie.postgis.net/download/windows/pg94/buildbot/extras
+[12]: https://winnie.postgis.net/download/windows/pg95/buildbot/
+[13]: https://winnie.postgis.net/download/windows/pg96/buildbot/
+[14]: https://winnie.postgis.net/download/windows/pg10/buildbot/
+[15]: https://winnie.postgis.net/download/windows/pg11/buildbot/
+[16]: https://winnie.postgis.net/download/windows/pg12/buildbot/
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/released_versions.md b/content/documentation/getting_started/install_windows/released_versions.md
new file mode 100644
index 0000000..11f90a8
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/released_versions.md
@@ -0,0 +1,56 @@
+---
+title: Released Versions
+date: 2022-02-01
+weight: 10
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+PostGIS 3.3.2 came out Nov 13, 2022. Windows PostGIS Bundle 3.3.2 was originally released Nov 21st, 2022 and rereleased on Dec 2nd, 2022.
+
+The rerelease includes updated pgRouting updated to 3.4.2 and a [fix for packaging issue of raster2pgsql](https://trac.osgeo.org/postgis/ticket/5292).
+
+There was also an issue with the PostgreSQL 13 which made it inaccessible from application stackbuilder.
+
+Binaries for versions of PostgreSQL 11-15 (64-bit) available in `Unreleased PostGIS Versions` and [OSGeo downloads][5]). Installers for 11-15(64-bit) are available on stackbuilder and [OSGeo downloads][5].
+
+New feature in this release is [h3-pg](https://github.com/zachasme/h3-pg) which includes `h3` and `h3_postgis` extensions for utilizing Uber's Hexagon indexing system within PostgreSQL.
+
+If you are using PostgreSQL < 11, use the PostGIS 3.2.3 bundle, because PostGIS 3.3+ does not support those versions.
+
+PostGIS 3.3.2 bundle includes:
+
+ * PostGIS 3.3.2 with MVT support, with raster, [GEOS](https://libgeos.org/posts/2022-11-14-geos-3-11-1-released/) 3.11.1, [PROJ](https://proj.org/download.html#past-releases) 7.2.1, [SFCGAL](http://sfcgal.org) support (1.4.1), address_standardizer, topology
+ * PostGIS Tiger geocoder extension - Tiger 2022
+ * pgRouting 3.4 [pgRouting 3.4.2](https://docs.pgrouting.org/3.4/en/index.html)
+ * Commandline raster loader (raster2pgsql), shapefile import/export (shp2pgsql,pgsql2shp)
+ * Commandline [osm2pgrouting 2.3.8](https://github.com/pgRouting/osm2pgrouting/wiki/Documentation-for-osm2pgrouting-v2.3) for loading data from .osm files into pgRouting routable format
+ * GUI: shp2pgsql-gui which has both import and export support for geometry/geography
+ * [ogrfdw 1.1.3](https://github.com/pramsey/pgsql-ogr-fdw/releases/tag/v1.1.3) - spatial foreign data wrapper for
+ reading both spatial (spatial columns become postgis geometry) and non-spatial data. [IMPORT FOREIGN SCHEMA](http://www.postgresonline.com/journal/archives/359-Import-Foreign-Schema-for-ogr_fdw-for-PostgreSQL-9.5.html) support
+ New features in 1.1 - `character_encoding` option and utility functions `ogr_fdw_drivers()`, `ogr_fdw_version()`
+
+ * [GDAL 3.4.3](https://gdal.org/download.html#current-releases) with OpenJPEG 2.4.0 (JPEG 2000), ODBC, Curl, SQLite3 (for GeoPackage and OSM support), excel (XLS) (via FreeXL 1.0.6), libreoffice, XLSX spreadsheet (via expat) (used by both PostGIS raster and ogrfdw)
+ * [pgpointcloud](https://github.com/pgpointcloud/pointcloud) 1.2.4
+ for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry
+ * [h3-pg](https://github.com/zachasme/h3-pg) 4.0.3 - this is the first PostGIS Bundle to include this feature
+ for using Uber h3 api and converting h3 index representations to postgis geometry/geography.
+
+The simplest way to get PostGIS on Windows for the EnterpriseDb Windows PostgreSQL distribution is using the StackBuilder.
+
+Refer to [An Almost Idiot's Guide Installing PostGIS on Windows][4]
+
+ 1. Download and install PostgreSQL [from EnterpriseDB](https://www.postgresql.org/download/windows/).
+ 2. Run the "StackBuilder" utility and install the PostGIS add-on.
+
+If you want to use the zip, setup, and setup source files directly
+they are available:
+
+* [Zip and Installer files][5] The .zip files are just the binaries you can copy into
+ your PostgreSQL installation and then enable in each database as usual. The exe are standard windows setup for 64-bit PostgreSQL.
+* [Source Setup files][6] The source setup files are useful if you want to build your own [NSIS installer][7] or create a single setup for your own project that also installs PostGIS. The [Binary zip files][5] should contain all the binary files you need to customize your own setup minus the documentation. You can also just extract the .exe setup file to get the binaries, but the extract sometimes gets mangled leaving out some of the postgis-gui subfolders.
+
+[4]: https://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
+[5]: https://download.osgeo.org/postgis/windows
+[6]: https://download.osgeo.org/postgis/windows/source
+[7]: http://nsis.sourceforge.net/Download
\ No newline at end of file
diff --git a/content/documentation/getting_started/install_windows/unreleased_versions.md b/content/documentation/getting_started/install_windows/unreleased_versions.md
new file mode 100644
index 0000000..c3a2cad
--- /dev/null
+++ b/content/documentation/getting_started/install_windows/unreleased_versions.md
@@ -0,0 +1,21 @@
+---
+title: Unreleased Versions
+date: 2022-02-01
+weight: 20
+geekdocHidden: true
+geekdocHiddenTocTree: false
+---
+
+If you are more adventurous, and risk-seeking you can partake in our experimental windows
+binaries of PostGIS built automatically by Winnie whenever there is a change in any of the PostGIS Stable or development branches. These are especially useful for testing out new features or if you are badly in need of a bug fix that has not been released yet.
+
+If you don't want to risk messing up an existing windows install or aren't allowed to write to the registry, we'd suggest using the companion [PostgreSQL EDB binaries-only][8] binaries which don't require installation. Setup is detailed in [Starting PostgreSQL in windows without install](http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html).
+
+## Windows: Winnie Bot PostGIS and pgRouting Experimental Builds
+
+* [for PostgreSQL 32-bit/64-bit][1]
+
+### Installing Experimental Binaries
+
+* Copy the contents of the respective folders in the zip file to your PostgreSQL install and when prompted to overwrite, overwrite
+* The newer GEOS will work with older PostGIS installs, but newest PostGIS will only work with the newer GEOS.
\ No newline at end of file
-----------------------------------------------------------------------
Summary of changes:
.../getting_started/install_windows.md | 147 ---------------------
.../getting_started/install_windows/_index.md | 15 +++
.../ci/01-04_win-pgrouting-2-4_branch.md | 62 +++++++++
.../ci/01-05_win-pgrouting-2-5_branch.md | 28 ++++
.../ci/02-05_win-pgrouting-2-6_branch.md | 28 ++++
.../ci/02-05_win-pgrouting-3-0_branch.md | 27 ++++
.../ci/04-04_win-postgis-2-3_branch.md | 25 ++++
.../ci/04-05_win-postgis-2-4_branch.md | 27 ++++
.../ci/04-06_win-postgis-2-5_branch.md | 27 ++++
.../ci/04-07_win-postgis-3-0_branch.md | 27 ++++
.../ci/04-07_win-postgis-3-1_branch.md | 27 ++++
.../ci/04-07_win-postgis-3-2_branch.md | 26 ++++
.../ci/04-07_win-postgis-3-3_branch.md | 26 ++++
.../getting_started/install_windows/ci/_index.md | 9 ++
.../install_windows/enabling_postgis.md | 68 ++++++++++
.../install_windows/released_versions.md | 56 ++++++++
.../install_windows/unreleased_versions.md | 21 +++
17 files changed, 499 insertions(+), 147 deletions(-)
delete mode 100644 content/documentation/getting_started/install_windows.md
create mode 100644 content/documentation/getting_started/install_windows/_index.md
create mode 100644 content/documentation/getting_started/install_windows/ci/01-04_win-pgrouting-2-4_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/01-05_win-pgrouting-2-5_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-2-6_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/02-05_win-pgrouting-3-0_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-04_win-postgis-2-3_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-05_win-postgis-2-4_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-06_win-postgis-2-5_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-0_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-1_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-2_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/04-07_win-postgis-3-3_branch.md
create mode 100644 content/documentation/getting_started/install_windows/ci/_index.md
create mode 100644 content/documentation/getting_started/install_windows/enabling_postgis.md
create mode 100644 content/documentation/getting_started/install_windows/released_versions.md
create mode 100644 content/documentation/getting_started/install_windows/unreleased_versions.md
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list