<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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 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;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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 tried your branch and was able to do <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'>CREATE EXTENSION mobilitydb;<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'>It took longer than the PG14 install though for that to run. Noticably slower but not a hug deal:<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:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'>CREATE EXTENSION Query returned successfully in 6 secs 898 msec.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'>As far as running the tests, it fails for me too, but I’m not sure it’s targeting the right thing, is there a debug setting (sorry not too familiar with cmake).<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'>I however did not bother pre-loading postgis-3, the PG14, PG15 tests I did worked without preload, but maybe it was because I had run some postgis stuff beforehand.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'><o:p> </o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Test project /home/robe/projects/MobilityDB/build<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 1: build<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 1/114 Test #1: build .............................. Passed 0.35 sec<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 2: setup<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 2/114 Test #2: setup .............................. Passed 5.03 sec<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 3: create_extension<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 3/114 Test #3: create_extension ...................***Failed 18.16 sec<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 5: load_tables<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Failed test dependencies: create_extension<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 4/114 Test #5: load_tables ........................***Not Run 0.00 sec<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 6: 001_period<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'><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'><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'> Regina Obe [mailto:lr@pcorp.us] <br><b>Sent:</b> Monday, May 23, 2022 11:49 AM<br><b>To:</b> 'Esteban Zimanyi' <estebanzimanyi@gmail.com><br><b>Cc:</b> 'SAKR Mahmoud' <mahmoud.sakr@ulb.be>; 'SCHOEMANS Maxime' <Maxime.Schoemans@ulb.be>; 'mobilitydb-dev@lists.osgeo.org' <mobilitydb-dev@lists.osgeo.org><br><b>Subject:</b> RE: [Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Great news. Thanks. I’ll give it another try. I’ll check on the tests.<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 couldn’t run the tests when I changed to compile against PG14 (but queries ran fine), so I suspect the tests might be hard-wired to run against your default PostgreSQL, which in my case is PG15.<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 [<a href="mailto:estebanzimanyi@gmail.com">mailto:estebanzimanyi@gmail.com</a>] <br><b>Sent:</b> Monday, May 23, 2022 11:38 AM<br><b>To:</b> Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>><br><b>Cc:</b> SAKR Mahmoud <<a href="mailto:mahmoud.sakr@ulb.be">mahmoud.sakr@ulb.be</a>>; SCHOEMANS Maxime <<a href="mailto:Maxime.Schoemans@ulb.be">Maxime.Schoemans@ulb.be</a>><br><b>Subject:</b> Re: [Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Dear Regina<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Many thanks for giving such detailed feedback for solving the issue of the pg_atoi missing function in PG_15. For a quick solution I have copy/pasted the original function that I only enable if PG version >= 15.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><a href="https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49">https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Now I can compile and use MobilityDB on PG 15 and PGIS 3.3 without any problem<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p><div><p class=MsoNormal>esteban@ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ psql test<br>psql (15beta1)<br>Type "help" for help.<br><br>test=# create extension mobilitydb cascade;<br>NOTICE: installing required extension "postgis"<br>CREATE EXTENSION<br>test=# select mobilitydb_full_version();<br> mobilitydb_full_version<br>-----------------------------------------------------<br> MobilityDB 1.0.0, PostgreSQL 15beta1, PostGIS 3.3.0<br>(1 row)<br><br>test=# select tintersects(tgeompoint '[Point(1 1)@2000-01-01, Point(3 3)@2000-01-03]',<br> tgeompoint '[Point(1 3)@2000-01-01, Point(3 1)@2000-01-03]');<br> tintersects<br>--------------------------------------------------------------------------------------------------------------<br> {[f@2000-01-01 00:00:00+01, t@2000-01-02 00:00:00+01], (f@2000-01-02 00:00:00+01, f@2000-01-03 00:00:00+01]}<br>(1 row)<br><br>test=#<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>However, I cannot run the MobilityDB regression tests<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><o:p> </o:p></p></div><div><p class=MsoNormal>esteban@ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ make test<br>Running tests...<br>Test project /home/esteban/src/MobilityDB/build<br> Start 1: build<br> 1/114 Test #1: build .............................. Passed 0.17 sec<br> Start 2: setup<br> 2/114 Test #2: setup .............................. Passed 2.97 sec<br> Start 3: create_extension<br> 3/114 Test #3: create_extension ...................***Failed 16.41 sec<br> Start 5: load_tables<br>Failed test dependencies: create_extension<o:p></o:p></p></div><div><div><p class=MsoNormal>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div></div><div><p class=MsoNormal>despite I have modified the postgresql.conf file as required by setting <o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>shared_preload_libraries = 'postgis-3'<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I have the following errors in the file <a href="file:///\\wsl$\Ubuntu\home\esteban\src\MobilityDB\build\tmptest\log\create_ext.log">\\wsl$\Ubuntu\home\esteban\src\MobilityDB\build\tmptest\log\create_ext.log</a><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>...<o:p></o:p></p></div><div><p class=MsoNormal>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17652: NOTICE: argument type stbox is only a shell<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17736: ERROR: type box2d does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17740: ERROR: type box3d does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17744: ERROR: type geometry does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17748: ERROR: type geography does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17768: ERROR: type geometry does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17772: ERROR: type geography does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17776: ERROR: type geometry does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17780: ERROR: type geography does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17782: ERROR: type "box2d" does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17783: ERROR: type "box3d" does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17784: ERROR: type "geometry" does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17785: ERROR: type "geography" does not exist<br>psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17800: NOTICE: type "geometry" is not yet defined<o:p></o:p></p></div><div><p class=MsoNormal>...<o:p></o:p></p></div><div><div><p class=MsoNormal>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Do you have any idea why this is the case ?<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>On Sun, May 22, 2022 at 9:12 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'><p class=MsoNormal>I have multiple versions of PostgreSQL installed on my Ubuntu server.<br><br>I can't figure out how to install against a particular version.<br><br>I've tried this:<br><br>cd MobilityDB<br>export PGVER=14<br>export PGPATH=/usr/lib/postgresql/${PGVER}<br>export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin<br>rm -rf build<br>mkdir build<br>cd build<br>cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..<br><br>and I tried this:<br><br>cd MobilityDB<br>export PGVER=14<br>export PGPATH=/usr/lib/postgresql/${PGVER}<br>export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin<br>rm -rf build<br>mkdir build<br>cd build<br>cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..<br><br><br>#I also explicitly tried setting the POSTGRESQL_BIN_DIR via cmake.<br>Regardless what I do it still outputs:<br><br>-- POSTGRESQL_VERSION_MAJOR=15<br>-- POSTGRESQL_VERSION_MINOR=0<br>-- POSTGRESQL_BIN_DIR: /usr/lib/postgresql/15/bin<br>-- POSTGRESQL_INCLUDE_DIR: /usr/include/postgresql/15/server<br>-- POSTGRESQL_LIBRARIES: /usr/lib/aarch64-linux-gnu<br>-- POSTGRESQL_SHARE_DIR: /usr/share/postgresql/15<br>-- POSTGRESQL_DYNLIB_DIR: /usr/lib/postgresql/15/lib<br>-- POSTGRESQL_VERSION: 15.0<br><br>As I mentioned in this issue, mobilitydb does not work against PostgreSQL 15<br><br><a href="https://github.com/MobilityDB/MobilityDB/issues/218" target="_blank">https://github.com/MobilityDB/MobilityDB/issues/218</a><br><br>Thanks,<br>Regina<br><br><br><br>_______________________________________________<br>Mobilitydb-dev mailing list<br><a href="mailto:Mobilitydb-dev@lists.osgeo.org" target="_blank">Mobilitydb-dev@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/mobilitydb-dev" target="_blank">https://lists.osgeo.org/mailman/listinfo/mobilitydb-dev</a><o:p></o:p></p></blockquote></div></div></div></div></body></html>