[postgis-tickets] [SCM] postgis.net branch website updated. clarity-final-21-g04da8db

git at osgeo.org git at osgeo.org
Wed May 24 20:39:53 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 has been updated
       via  04da8db344380675de14b1397d0e2c81b7320584 (commit)
      from  a3218338cb5d08ce61c1e509bb5ef8fb50ec0318 (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 04da8db344380675de14b1397d0e2c81b7320584
Author: Regina Obe <lr at pcorp.us>
Date:   Wed May 24 23:39:46 2023 -0400

    Announce availability of mobilitydb binaries for windows

diff --git a/content/documentation/getting_started/install_windows/enabling_postgis.md b/content/documentation/getting_started/install_windows/enabling_postgis.md
index edb60d7..e47758e 100644
--- a/content/documentation/getting_started/install_windows/enabling_postgis.md
+++ b/content/documentation/getting_started/install_windows/enabling_postgis.md
@@ -30,6 +30,7 @@ CREATE EXTENSION postgis_tiger_geocoder;
 These extensions are part of the PostGIS bundle, but you can also download
 the latest separately in [Unreleased Versions](../unreleased_versions).
 
+#### pgRouting
 As the crow flies distance is not enough, and you need real measures
 of time based on road paths, walking paths, bike paths, and other obstacles,
 then pgRouting is for you.  Run below to start your routing journey.
@@ -38,10 +39,10 @@ then pgRouting is for you.  Run below to start your routing journey.
 CREATE EXTENSION pgrouting;
 ```
 
-For loading OpenStreetMap data (OSM) into pgrouting format, you can use [osm2pgrouting][10] 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.
+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.
 
-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` PostgreSQL versioned folder if you want to use not yet released versions.
+####  Additional extensions included in the PostGIS Bundle, that are not part of PostGIS project
+These extension you'll find in the `extras` PostgreSQL versioned folder if you want to use not yet released versions.
 
 ```postgres
 -- foreign data wrapper for querying external spatial
@@ -56,20 +57,32 @@ CREATE EXTENSION pointcloud_postgis;
 CREATE EXTENSION h3;
 CREATE EXTENSION h3_postgis;
 ```
+#### MobilityDb
+Mobilitydb is for managing trajectory data.  Refer to https://github.com/MobilityDB/MobilityDB for details.
+The mobilitydb extension, is not yet part of the PostGIS Bundle, but you will find the in develop version
+available in the `extras` [PostgreSQL versioned](https://winnie.postgis.net/download/windows/) folders.  It will also be available in PostGIS bundle soon.
 
+```postgres
+-- confirm you don't have any existing pre-loaded libraries,
+-- if you do make sure to readd when alter system
+SHOW shared_preload_libraries;
+ALTER SYSTEM  SET shared_preload_libraries = 'postgis-3';
+
+SHOW max_locks_per_transaction;
+
+-- if lower than 128, then run the below
+ALTER SYSTEM SET max_locks_per_transaction = 128;
+```
+
+From Windows services, restart the PostgreSQL service.
+
+Now you are ready to enable mobilitydb in a database:
+
+```
+CREATE EXTENSION mobilitydb;
+```
 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/

-----------------------------------------------------------------------

Summary of changes:
 .../install_windows/enabling_postgis.md            | 41 ++++++++++++++--------
 1 file changed, 27 insertions(+), 14 deletions(-)


hooks/post-receive
-- 
postgis.net


More information about the postgis-tickets mailing list