<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Esteban,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I’ll take a look at this week. I’ve been in the middle of transitioning my msys2 setup to newer GCC/mongw64. My current one last I tried couldn’t compile mobilitydb. I’ll try again before my next packaging. So that’s what’s been taking so long.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I do have h3-pg built using the new setup, but that was a much simpler extension, didn’t need all the pieces needed by PostGIS too.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I’ll keep you posted.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'>From:</span></b><span style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Esteban Zimanyi [mailto:esteban.zimanyi@ulb.be] <br><b>Sent:</b> Wednesday, May 24, 2023 1:52 AM<br><b>To:</b> PostGIS Development Discussion <postgis-devel@lists.osgeo.org><br><b>Cc:</b> SAKR Mahmoud <mahmoud.sakr@ulb.be>; Faisal Moeen <fmorakzai@gmail.com>; Alejandro Vaisman <avaisman@itba.edu.ar>; Regina Obe <lr@pcorp.us>; Graser Anita <anita.graser@ait.ac.at>; Vicky Vergara <vicky@georepublic.de><br><b>Subject:</b> MobilityDB is ready to be packaged for Windows together with PostGIS<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>MobilityDB is an open-source geospatial trajectory data management and analytics platform based on PostgreSQL and PostGIS<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://mobilitydb.com/">https://mobilitydb.com/</a><o:p></o:p></p></div><div><div><p class=MsoNormal>MobilityDB is an OSGeo Community project<o:p></o:p></p></div><p class=MsoNormal><a href="https://www.osgeo.org/projects/mobilitydb/" target="_blank">https://www.osgeo.org/projects/mobilitydb/</a><o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>A recurrent request from users is to have a Windows version<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://github.com/MobilityDB/MobilityDB/issues/176" target="_blank">https://github.com/MobilityDB/MobilityDB/issues/176</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>We are able to generate a Windows version using msys2 both in Github<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://github.com/MobilityDB/MobilityDB/actions/runs/5059343801/jobs/9080732581" target="_blank">https://github.com/MobilityDB/MobilityDB/actions/runs/5059343801/jobs/9080732581</a><o:p></o:p></p></div><div><p class=MsoNormal>and locally as in the script below.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>How can we work together with the PostGIS community to release MobilityDB along with PostGIS in the standard Windows bundle for PostgreSQL ?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Many thanks for your help<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Esteban<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>----------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal>Install msys2 as explained in the web site below<br><a href="https://www.msys2.org/" target="_blank">https://www.msys2.org/</a><br><br>After executing the installer, do the following on the MSYS2 UCRT64 prompt<br><br>$ pacman -S mingw-w64-ucrt-x86_64-gcc<br>$ pacman -S mingw-w64-ucrt-x86_64-cmake<br>$ pacman -S mingw-w64-ucrt-x86_64-postgis<br>$ pacman -S mingw-w64-ucrt-x86_64-gsl<br>$ pacman -S git<br>$ pacman -Syyu<br>$ export PGDATA="C:/msys64/usr/local/pgsql/data"<br>$ export PGPORT=5434<br>$ initdb<br>$ pg_ctl start<br>$ createdb mydb<br>$ psql mydb<br>psql (15.1)<br>WARNING: Console code page (437) differs from Windows code page (1252)<br> 8-bit characters might not work correctly. See psql reference<br> page "Notes for Windows users" for details.<br>Type "help" for help.<br><br>mydb=# SELECT version();<br> version<br>----------------------------------------------------------------------------------------------------------<br> PostgreSQL 15.1 on x86_64-w64-mingw32, compiled by gcc.exe (Rev7, Built by MSYS2 project) 12.2.0, 64-bit<br>(1 row)<br><br>mydb=# CREATE EXTENSION postgis;<br>CREATE EXTENSION<br>mydb=# SELECT postgis_full_version();<br> postgis_full_version<br>----------------------------------------------------------------------------------------------------------------------<br> 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"<br>(1 row)<br>---------------------------------------------------------------------------------<br><br>After this first step continue building MobilityDB<br><br>$ git clone <a href="https://github.com/MobilityDB/MobilityDB.git" target="_blank">https://github.com/MobilityDB/MobilityDB.git</a><br>$ cd MobilityDB/<br>$ mkdir build<br>$ cd build<br>$ git checkout develop<br>$ cmake ..<br>$ cmake --build .<br>$ cmake --install .<br><br>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<br><br>shared_preload_libraries = 'postgis-3.dll'<br>max_locks_per_transaction = 128<br>timezone = 'UTC'<br>parallel_tuple_cost = 100<br>parallel_setup_cost = 100<br>force_parallel_mode = off<br>min_parallel_table_scan_size = 0<br>min_parallel_index_scan_size = 0<br><br>Continue on the MSYS2 UCRT64 prompt<br><br>$ pg_ctl restart<br>$ psql mydb<br>psql (15.1)<br>WARNING: Console code page (437) differs from Windows code page (1252)<br> 8-bit characters might not work correctly. See psql reference<br> page "Notes for Windows users" for details.<br>Type "help" for help.<br><br>mydb=# create extension mobilitydb;<br>CREATE EXTENSION<br>mydb=# select mobilitydb_full_version();<br> mobilitydb_full_version<br>--------------------------------------------------------------------------------------<br> MobilityDB 1.1.0, PostgreSQL 15.1, PostGIS 3.3.1, GEOS 3.9.1-CAPI-1.14.2, PROJ 9.2.0<br>(1 row)<br><br>mydb=# select tfloat '1@2000-01-01';<br> tfloat<br>--------------------------<br> 1@2000-01-01 00:00:00+00<br>(1 row)<br>------------------------------------------------------------<o:p></o:p></p></div><div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><p class=MsoNormal><span style='color:#888888'><o:p> </o:p></span></p></div></div></div></div></div></body></html>