[SCM] postgis.net branch website updated. clarity-final-123-g80bdb68
git at osgeo.org
git at osgeo.org
Sun Oct 20 15:31:18 PDT 2024
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 80bdb68b125bd865bca400fedbf66639514d0167 (commit)
from 6a80288992c91921825f0bf1ee666c112402103a (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 80bdb68b125bd865bca400fedbf66639514d0167
Author: Regina Obe <lr at pcorp.us>
Date: Sun Oct 20 18:30:35 2024 -0400
Announce new PostGIS 3.5.0 bundle
- now available for PG 13-17
- Update how to install extensions page
diff --git a/content/documentation/getting_started/install_windows/enabling_postgis.md b/content/documentation/getting_started/install_windows/enabling_postgis.md
index 6cc2e09..c1fde57 100644
--- a/content/documentation/getting_started/install_windows/enabling_postgis.md
+++ b/content/documentation/getting_started/install_windows/enabling_postgis.md
@@ -23,6 +23,10 @@ CREATE EXTENSION postgis_topology;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION postgis_tiger_geocoder;
+
+
+-- need to upgrade the postgis packaged extensions do
+SELECT postgis_extensions_upgrade();
```
### PostGIS related extensions
@@ -37,6 +41,12 @@ then pgRouting is for you. Run below to start your routing journey.
```postgres
CREATE EXTENSION pgrouting;
+
+-- for upgrading an existing install
+ALTER EXTENSION pgrouting UPDATE;
+
+-- see version details
+SELECT * FROM pgr_full_version();
```
For loading OpenStreetMap data (OSM) into pgrouting format, you can use [osm2pgrouting](http://pgrouting.org/docs/tools/osm2pgrouting.html) or [osm2po](https://osm2po.de/). Windows binaries for osm2pgrouting can be found alongside pgrouting for each version and are included in the windows bundle. Refer to instructions in the zip.
@@ -49,13 +59,20 @@ These extension you'll find in the `extras` PostgreSQL versioned folder if you w
and non-spatial data sources
Note if you get an error accessing https sources,
you need to define the CURL_CA_BUNDLE system environment variable to something like
- C:\Program Files\PostgreSQL\15\ssl\certs\ca-bundle.crt **/
+ C:\Program Files\PostgreSQL\15\ssl\certs\ca-bundle.crt
+ This is an option in installer for PostGIS 3.4.1 bundle and above**/
CREATE EXTENSION ogr_fdw;
-- for managing pointcloud data
CREATE EXTENSION pointcloud;
CREATE EXTENSION pointcloud_postgis;
+-- see version installed
+SELECT pc_version();
+
+-- upgrade
+ALTER EXTENSION pointcloud UPDATE;
+ALTER EXTENSION pointcloud_postgis UPDATE;
-- for using Uber h3 indexing scheme
CREATE EXTENSION h3;
@@ -84,6 +101,10 @@ Now you are ready to enable mobilitydb in a database.
```
CREATE EXTENSION mobilitydb;
+-- show current version and dependencies
+SELECT mobilitydb_full_version();
+-- updating existing install
+ALTER EXTENSION mobilitydb UPDATE;
```
If you failed to do the above steps or restart your service, you might get an error
diff --git a/content/documentation/getting_started/install_windows/released_versions.md b/content/documentation/getting_started/install_windows/released_versions.md
index f71513d..ceb7507 100644
--- a/content/documentation/getting_started/install_windows/released_versions.md
+++ b/content/documentation/getting_started/install_windows/released_versions.md
@@ -6,15 +6,15 @@ geekdocHidden: true
geekdocHiddenTocTree: false
---
-PostGIS 3.5.0 came out September 26th, 2024. Windows PostGIS Bundle 3.5.0 installer for PostgreSQL 17 was released September 28th, 2024.
+PostGIS 3.5.0 came out September 26th, 2024. Windows PostGIS Bundle 3.5.0 installer for PostgreSQL 17 was released September 28th, 2024. On October 20th 2024, PostgreSQL 17 3.5.0 bundle was rereleased with updates for pgRouting (from 3.6.2 to 3.6.3) and mobilityDb 1.2.0rc1 to 1.2.0. PostGIS Bundle 3.5.0 for 13-16 also release on October 20th 2024.
-Binaries for versions of PostgreSQL 12-17 (64-bit) available in `Unreleased PostGIS Versions` and [OSGeo downloads][5]). Installers for 13-16(64-bit) will be available soon on [OSGeo downloads][5].
+Binaries for versions of PostgreSQL 12-17 (64-bit) available in `Unreleased PostGIS Versions` and [OSGeo downloads][5]). Installers for 13-17(64-bit) available on [OSGeo downloads][5] and application stackbuilder.
PostGIS 3.5.0 bundle includes:
- * PostGIS 3.5.0 with MVT support, with raster, [GEOS](https://libgeos.org/posts/2023-11-11-geos-3-12-1-released/) 3.13.0, [PROJ](https://proj.org/download.html#past-releases) 8.2.1, [SFCGAL](http://sfcgal.org) support (1.5.2), address_standardizer, topology
+ * PostGIS 3.5.0 with MVT support, with raster, [GEOS](https://libgeos.org/posts/2024-09-06-geos-3-13-released/) 3.13.0, [PROJ](https://proj.org/download.html#past-releases) 8.2.1, [SFCGAL](http://sfcgal.org) support (1.5.2), address_standardizer, topology
* PostGIS Tiger geocoder extension - Tiger 2023
- * pgRouting 3.6 [pgRouting 3.6.2](https://docs.pgrouting.org/3.6/en/index.html)
+ * pgRouting 3.6 [pgRouting 3.6.3](https://docs.pgrouting.org/3.6/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
@@ -28,7 +28,7 @@ PostGIS 3.5.0 bundle includes:
for querying LIDAR point cloud and in/out functions to convert to PostGIS geometry
* [h3-pg](https://github.com/zachasme/h3-pg) 4.1.3
for using Uber h3 api and converting h3 index representations to postgis geometry/geography/raster (raster support is new in this release).
- * [MobilityDB](https://mobilitydb.com) [v1.2.0rc1](https://github.com/MobilityDB/MobilityDB/releases/tag/v1.2.0rc1)
+ * [MobilityDB](https://mobilitydb.com) [v1.2.0](https://github.com/MobilityDB/MobilityDB/releases/tag/v1.2.0)
for managing trajectories. Includes many temporal spatial types and functions for them. Refer to [Enabling PostGIS Extensions: MobilityDb](../enabling_postgis/#mobilitydb) for guidance.
The simplest way to get PostGIS on Windows for the EnterpriseDb Windows PostgreSQL distribution is using the StackBuilder.
-----------------------------------------------------------------------
Summary of changes:
.../install_windows/enabling_postgis.md | 23 +++++++++++++++++++++-
.../install_windows/released_versions.md | 10 +++++-----
2 files changed, 27 insertions(+), 6 deletions(-)
hooks/post-receive
--
postgis.net
More information about the postgis-tickets
mailing list