[postgis-devel] MobilityDB is ready to be packaged for Windows together with PostGIS

[Esteban Zimanyi]

MobilityDB is an open-source geospatial trajectory data management and
analytics platform based on PostgreSQL and PostGIS
https://mobilitydb.com/
MobilityDB is an OSGeo Community project
https://www.osgeo.org/projects/mobilitydb/

A recurrent request from users is to have a Windows version
https://github.com/MobilityDB/MobilityDB/issues/176

We are able to generate a Windows version using msys2 both in Github
https://github.com/MobilityDB/MobilityDB/actions/runs/5059343801/jobs/9080732581
and locally as in the script below.

How can we work together with the PostGIS community to release MobilityDB
along with PostGIS in the standard Windows bundle for PostgreSQL ?

Many thanks for your help

Esteban

----------------------------------------------------------------------------------------------------
Install msys2 as explained in the web site below
https://www.msys2.org/

After executing the installer, do the following on the MSYS2 UCRT64 prompt

$ pacman -S mingw-w64-ucrt-x86_64-gcc
$ pacman -S mingw-w64-ucrt-x86_64-cmake
$ pacman -S mingw-w64-ucrt-x86_64-postgis
$ pacman -S mingw-w64-ucrt-x86_64-gsl
$ pacman -S git
$ pacman -Syyu
$ export PGDATA="C:/msys64/usr/local/pgsql/data"
$ export PGPORT=5434
$ initdb
$ pg_ctl start
$ createdb mydb
$ psql mydb
psql (15.1)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

mydb=# SELECT version();
                                                 version
----------------------------------------------------------------------------------------------------------
 PostgreSQL 15.1 on x86_64-w64-mingw32, compiled by gcc.exe (Rev7, Built by
MSYS2 project) 12.2.0, 64-bit
(1 row)

mydb=# CREATE EXTENSION postgis;
CREATE EXTENSION
mydb=# SELECT postgis_full_version();
                                                 postgis_full_version
----------------------------------------------------------------------------------------------------------------------
 POSTGIS="3.3.1 3786b21" [EXTENSION] PGSQL="150" GEOS="3.9.1-CAPI-1.14.2"
PROJ="9.2.0" LIBXML="2.10.3" LIBJSON="0.16"
(1 row)
---------------------------------------------------------------------------------

After this first step continue building MobilityDB

$ git clone https://github.com/MobilityDB/MobilityDB.git
$ cd MobilityDB/
$ mkdir build
$ cd build
$ git checkout develop
$ cmake ..
$ cmake --build .
$ cmake --install .

Edit the file C:\msys64\usr\local\pgsql\data\postgresql.conf with your
favorite editor (e.g. Notepad++) and add at the end the following lines

shared_preload_libraries = 'postgis-3.dll'
max_locks_per_transaction = 128
timezone = 'UTC'
parallel_tuple_cost = 100
parallel_setup_cost = 100
force_parallel_mode = off
min_parallel_table_scan_size = 0
min_parallel_index_scan_size = 0

Continue on the MSYS2 UCRT64 prompt

$ pg_ctl restart
$ psql mydb
psql (15.1)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

mydb=# create extension mobilitydb;
CREATE EXTENSION
mydb=# select mobilitydb_full_version();
                               mobilitydb_full_version
--------------------------------------------------------------------------------------
 MobilityDB 1.1.0, PostgreSQL 15.1, PostGIS 3.3.1, GEOS 3.9.1-CAPI-1.14.2,
PROJ 9.2.0
(1 row)

mydb=# select tfloat '1 at 2000-01-01';
          tfloat
--------------------------
 1 at 2000-01-01 00:00:00+00
(1 row)
------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230524/18a1d4e4/attachment.htm>