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. Can someone instructs us how to package MobilityDB so it can be added using e.g. Stackbuilder (as it is done for PostGIS) to an existing PostgreSQL database in Windows ? We have been struggling for long time to achieve this and haven't found a way to do it :-( 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-ninja $ 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@2000-01-01'; tfloat -------------------------- 1@2000-01-01 00:00:00+00 (1 row) ------------------------------------------------------------ Regards Esteban
_______________________________________________ osgeo4w-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/osgeo4w-dev
