[postgis-tickets] [SCM] postgis.net branch website updated. 628d3b559888eda85198842f5ef0d62ed6a26f55
git at osgeo.org
git at osgeo.org
Tue Nov 22 08:51:00 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, website has been updated
via 628d3b559888eda85198842f5ef0d62ed6a26f55 (commit)
from 52b6ddc4183553e93c8851322c3bf46bb2e09c8d (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 628d3b559888eda85198842f5ef0d62ed6a26f55
Author: Regina Obe <lr at pcorp.us>
Date: Tue Nov 22 11:50:52 2022 -0500
additional instructions how to install other postgis related extensions
diff --git a/content/pages/windows_downloads/index.md b/content/pages/windows_downloads/index.md
index df53b6b..2464c4f 100644
--- a/content/pages/windows_downloads/index.md
+++ b/content/pages/windows_downloads/index.md
@@ -88,7 +88,7 @@ Setup is detailed in [Starting PostgreSQL in windows without install](http://www
## Enabling PostGIS
-PostGIS is an optional extension that must be enabled in EVERY database you want to use it in.
+PostGIS and other extensions are optional extensions that must be enabled in EVERY database you want to use them in.
```postgres
CREATE EXTENSION postgis;
@@ -103,6 +103,8 @@ 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
If you want to use pgrouting, download the respective one for your PostgreSQL/
@@ -111,9 +113,26 @@ 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 in the `extras` folder of each version. Refer to instructions in the zip.
+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 [install](/install) section for more guidance.
-----------------------------------------------------------------------
Summary of changes:
content/pages/windows_downloads/index.md | 23 +++++++++++++++++++++--
1 file changed, 21 insertions(+), 2 deletions(-)
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list