<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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-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'>I put the postgis-3.0 in shared libraries and I tried and restarted my service but I get the same issue failing at CREATE EXTENSION on my PG14.3 instance during the tests.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Works fine when I run things. <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 see you are creating a new cluster and have the shared happen during that. All paths at a in the test.sh look okay.<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'>The logs show:<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>3/112 Testing: 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/112 Test: 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"'>Command: "/home/robe/projects/MobilityDB/build/test/scripts/test.sh" "create_ext"<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Directory: /home/robe/projects/MobilityDB/build/test/scripts<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>"create_extension" start time: May 25 13:31 UTC<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Output:<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>----------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>pg_ctl: server is running (PID: 7237)<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>/usr/lib/postgresql/14/bin/postgres "-D" "/home/robe/projects/MobilityDB/build/tmptest/db" "-k" "/home/robe/projects/MobilityDB/build/tmptest/lock" "-h" ""<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'><end of output><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Test time = 18.62 sec<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>----------------------------------------------------------<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Test Failed.<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>"create_extension" end time: May 25 13:31 UTC<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>"create_extension" time elapsed: 00:00:18<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span style='font-size:16.0pt;font-family:"Lucida Console"'>----------------------------------------------------------<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><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'>BTW is there a reason you removed your PG15 patch fix branch. I didn’t see the code committed anywhere yet and I made the mistake of updating and now can’t CREATE EXTENSION against PG15 doesn’t work anymore </span><span style='font-size:11.0pt;font-family:Wingdings;color:#1F497D'>L</span><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'> Esteban Zimanyi [mailto:estebanzimanyi@gmail.com] <br><b>Sent:</b> Monday, May 23, 2022 4:19 PM<br><b>To:</b> Regina Obe <lr@pcorp.us><br><b>Cc:</b> SAKR Mahmoud <mahmoud.sakr@ulb.be>; SCHOEMANS Maxime <Maxime.Schoemans@ulb.be>; 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><div><div><p class=MsoNormal>Maybe you can test on your PG 14 installation to preload PostGIS and run the tests. This should work<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true">https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true</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>On Mon, May 23, 2022, 22:11 Esteban Zimanyi <<a href="mailto:estebanzimanyi@gmail.com" target="_blank">estebanzimanyi@gmail.com</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-right:0in'><div><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>I suspect that a possible cause for this problem is that PG 15 does not really preload the postgis-3 extension. This is why you have the output as myself that the MobilityDB extension failed at test 3/114. The output I sent you in the previous email was the log of this operation.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>How to test whether the PostGIS extension is fully loaded before running the SQL script of the MobilityDB extension ?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><div><p class=MsoNormal>On Mon, May 23, 2022, 21:50 Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">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-right:0in'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Esteban,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>I tried your branch and was able to do </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>CREATE EXTENSION mobilitydb;</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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:</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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).</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Test project /home/robe/projects/MobilityDB/build</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 1: build</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 1/114 Test #1: build .............................. Passed 0.35 sec</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 2: setup</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 2/114 Test #2: setup .............................. Passed 5.03 sec</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 3: create_extension</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 3/114 Test #3: create_extension ...................***Failed 18.16 sec</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 5: load_tables</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'>Failed test dependencies: create_extension</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> 4/114 Test #5: load_tables ........................***Not Run 0.00 sec</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:16.0pt;font-family:"Lucida Console"'> Start 6: 001_period</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:Consolas;color:#222222;letter-spacing:.1pt;background:white'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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:<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>] <br><b>Sent:</b> Monday, May 23, 2022 11:49 AM<br><b>To:</b> 'Esteban Zimanyi' <<a href="mailto:estebanzimanyi@gmail.com" target="_blank">estebanzimanyi@gmail.com</a>><br><b>Cc:</b> 'SAKR Mahmoud' <<a href="mailto:mahmoud.sakr@ulb.be" target="_blank">mahmoud.sakr@ulb.be</a>>; 'SCHOEMANS Maxime' <<a href="mailto:Maxime.Schoemans@ulb.be" target="_blank">Maxime.Schoemans@ulb.be</a>>; '<a href="mailto:mobilitydb-dev@lists.osgeo.org" target="_blank">mobilitydb-dev@lists.osgeo.org</a>' <<a href="mailto:mobilitydb-dev@lists.osgeo.org" target="_blank">mobilitydb-dev@lists.osgeo.org</a>><br><b>Subject:</b> RE: [Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu</span><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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" target="_blank">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" target="_blank">lr@pcorp.us</a>><br><b>Cc:</b> SAKR Mahmoud <<a href="mailto:mahmoud.sakr@ulb.be" target="_blank">mahmoud.sakr@ulb.be</a>>; SCHOEMANS Maxime <<a href="mailto:Maxime.Schoemans@ulb.be" target="_blank">Maxime.Schoemans@ulb.be</a>><br><b>Subject:</b> Re: [Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu</span><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Dear Regina<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><a href="https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49" target="_blank">https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49</a><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>However, I cannot run the MobilityDB regression tests<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>despite I have modified the postgresql.conf file as required by setting <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>shared_preload_libraries = 'postgis-3'<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>...<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>...<o:p></o:p></p></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>--------------------------------------------------------------------------------------------------------------<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Do you have any idea why this is the case ?<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Many thanks for your help<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Esteban<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>On Sun, May 22, 2022 at 9:12 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>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></div></blockquote></div></div></div></blockquote></div></div></div></body></html>