<div dir="ltr"><div dir="ltr"><br clear="all"><div><div dir="ltr" data-smartmail="gmail_signature"><div dir="ltr"><div>I have just installed the sources and compiled PG 14.3 and I was able to run the tests without any problems.</div><div><br></div><div>-----------------------------------------------------------------------------<br></div><div><br></div><div>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/113 Test #1: build .............................. Passed 0.18 sec<br> Start 2: setup<br> 2/113 Test #2: setup .............................. Passed 3.07 sec<br> Start 3: create_extension<br> 3/113 Test #3: create_extension ................... Passed 17.20 sec<br> Start 5: load_tables<br> 4/113 Test #5: load_tables ........................ Passed 3.16 sec<br> Start 6: 001_period<br> 5/113 Test #6: 001_period ......................... Passed 0.02 sec<br> Start 7: 001_period_tbl<br> 6/113 Test #7: 001_period_tbl ..................... Passed 0.05 sec<br> Start 8: 003_timestampset<br></div><div>....</div><div>110/113 Test #110: 096_tnpoint_spatialrels_tbl ........ Passed 29.10 sec<br> Start 111: 096_tnpoint_spatialrels_tbl_pg12<br>111/113 Test #111: 096_tnpoint_spatialrels_tbl_pg12 ... Passed 0.12 sec<br> Start 112: 097_tnpoint_tempspatialrels<br>112/113 Test #112: 097_tnpoint_tempspatialrels ........ Passed 0.09 sec<br> Start 113: 097_tnpoint_tempspatialrels_tbl<br>113/113 Test #113: 097_tnpoint_tempspatialrels_tbl .... Passed 0.45 sec<br><br>100% tests passed, 0 tests failed out of 113<br><br>Total Test time (real) = 484.15 sec<br>esteban@ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ dropdb test<br>esteban@ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ createdb test<br>esteban@ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ psql test<br>psql (14.3)<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 14.3, PostGIS 3.2.1<br>(1 row)<br><br>test=#<br>-----------------------------------------------------------------------------<br></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 25, 2022 at 4:05 PM Esteban Zimanyi <<a href="mailto:estebanzimanyi@gmail.com" target="_blank">estebanzimanyi@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div>Dear Regina</div><div><br></div><div>The patch for PG 15 is now on the develop branch</div><div><a href="https://github.com/MobilityDB/MobilityDB/blob/develop/src/point/tpoint.c#L49" target="_blank">https://github.com/MobilityDB/MobilityDB/blob/develop/src/point/tpoint.c#L49</a><br></div><div><br></div><div>I will look at the other issue ASAP.</div><div><br></div><div>Regards</div><div><br></div><div>Esteban</div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, May 25, 2022 at 3:41 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Works fine when I run things. <u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">The logs show:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">3/112 Testing: create_extension<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">3/112 Test: create_extension<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Command: "/home/robe/projects/MobilityDB/build/test/scripts/test.sh" "create_ext"<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Directory: /home/robe/projects/MobilityDB/build/test/scripts<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">"create_extension" start time: May 25 13:31 UTC<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Output:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">----------------------------------------------------------<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">pg_ctl: server is running (PID: 7237)<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;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" ""<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""><end of output><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Test time = 18.62 sec<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">----------------------------------------------------------<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Test Failed.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">"create_extension" end time: May 25 13:31 UTC<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">"create_extension" time elapsed: 00:00:18<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">----------------------------------------------------------<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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:11pt;font-family:Wingdings;color:rgb(31,73,125)">L</span><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:Calibri,sans-serif"> Esteban Zimanyi [mailto:<a href="mailto:estebanzimanyi@gmail.com" target="_blank">estebanzimanyi@gmail.com</a>] <br><b>Sent:</b> Monday, May 23, 2022 4:19 PM<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>>; <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<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></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<u></u><u></u></p></div><div><p class="MsoNormal"><a href="https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true" target="_blank">https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true</a><u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal">Dear Regina<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></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 ?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></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:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><div><div><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Esteban,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I tried your branch and was able to do </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">CREATE EXTENSION mobilitydb;</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">It took longer than the PG14 install though for that to run. Noticably slower but not a hug deal:</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.1pt;background:white">CREATE EXTENSION Query returned successfully in 6 secs 898 msec.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.1pt;background:white"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.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><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.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><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.1pt;background:white"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Test project /home/robe/projects/MobilityDB/build</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> Start 1: build</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> 1/114 Test #1: build .............................. Passed 0.35 sec</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> Start 2: setup</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> 2/114 Test #2: setup .............................. Passed 5.03 sec</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> Start 3: create_extension</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> 3/114 Test #3: create_extension ...................***Failed 18.16 sec</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> Start 5: load_tables</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console"">Failed test dependencies: create_extension</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> 4/114 Test #5: load_tables ........................***Not Run 0.00 sec</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:16pt;font-family:"Lucida Console""> Start 6: 001_period</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.1pt;background:white"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:9pt;font-family:Consolas;color:rgb(34,34,34);letter-spacing:0.1pt;background:white"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;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><u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Great news. Thanks. I’ll give it another try. I’ll check on the tests.</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></p><div style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt solid blue;padding:0in 0in 0in 4pt"><div><div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in"><p class="MsoNormal"><b><span style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span style="font-size:11pt;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><u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><p class="MsoNormal">Dear Regina<u></u><u></u></p><div><p class="MsoNormal"> <u></u><u></u></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.<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal"><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><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Now I can compile and use MobilityDB on PG 15 and PGIS 3.3 without any problem<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></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=#<u></u><u></u></p></div><div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">However, I cannot run the MobilityDB regression tests<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></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<u></u><u></u></p></div><div><div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><div><p class="MsoNormal">despite I have modified the postgresql.conf file as required by setting <u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">shared_preload_libraries = 'postgis-3'<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">I have the following errors in the file <a>\\wsl$\Ubuntu\home\esteban\src\MobilityDB\build\tmptest\log\create_ext.log</a><u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></p></div><div><p class="MsoNormal">...<u></u><u></u></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<u></u><u></u></p></div><div><p class="MsoNormal">...<u></u><u></u></p></div><div><div><p class="MsoNormal">--------------------------------------------------------------------------------------------------------------<u></u><u></u></p></div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Do you have any idea why this is the case ?<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Many thanks for your help<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">Esteban<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div></div><p class="MsoNormal"> <u></u><u></u></p><div><div><p class="MsoNormal">On Sun, May 22, 2022 at 9:12 PM Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<u></u><u></u></p></div><blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt"><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><u></u><u></u></p></blockquote></div></div></div></div></div></blockquote></div></div></div></blockquote></div></div></div></div></blockquote></div>
</blockquote></div></div>