[Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu
Esteban Zimanyi
estebanzimanyi at gmail.com
Mon May 23 13:18:59 PDT 2022
Maybe you can test on your PG 14 installation to preload PostGIS and run
the tests. This should work
https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true
On Mon, May 23, 2022, 22:11 Esteban Zimanyi <estebanzimanyi at gmail.com>
wrote:
> Dear Regina
>
> 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.
>
> How to test whether the PostGIS extension is fully loaded before running
> the SQL script of the MobilityDB extension ?
>
>
>
> On Mon, May 23, 2022, 21:50 Regina Obe <lr at pcorp.us> wrote:
>
>> Esteban,
>>
>>
>>
>> I tried your branch and was able to do
>>
>>
>>
>> CREATE EXTENSION mobilitydb;
>>
>>
>>
>> It took longer than the PG14 install though for that to run. Noticably
>> slower but not a hug deal:
>>
>>
>>
>> CREATE EXTENSION Query returned successfully in 6 secs 898 msec.
>>
>>
>>
>> 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).
>>
>> 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.
>>
>>
>>
>> Test project /home/robe/projects/MobilityDB/build
>>
>> Start 1: build
>>
>> 1/114 Test #1: build .............................. Passed 0.35
>> sec
>>
>> Start 2: setup
>>
>> 2/114 Test #2: setup .............................. Passed 5.03
>> sec
>>
>> Start 3: create_extension
>>
>> 3/114 Test #3: create_extension ...................***Failed 18.16
>> sec
>>
>> Start 5: load_tables
>>
>> Failed test dependencies: create_extension
>>
>> 4/114 Test #5: load_tables ........................***Not Run 0.00
>> sec
>>
>> Start 6: 001_period
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *From:* Regina Obe [mailto:lr at pcorp.us]
>> *Sent:* Monday, May 23, 2022 11:49 AM
>> *To:* 'Esteban Zimanyi' <estebanzimanyi at gmail.com>
>> *Cc:* 'SAKR Mahmoud' <mahmoud.sakr at ulb.be>; 'SCHOEMANS Maxime' <
>> Maxime.Schoemans at ulb.be>; 'mobilitydb-dev at lists.osgeo.org' <
>> mobilitydb-dev at lists.osgeo.org>
>> *Subject:* RE: [Mobilitydb-dev] Configuring for a Particular PostgreSQL
>> on Ubuntu
>>
>>
>>
>> Great news. Thanks. I’ll give it another try. I’ll check on the tests.
>>
>>
>>
>> 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.
>>
>>
>>
>> *From:* Esteban Zimanyi [mailto:estebanzimanyi at gmail.com
>> <estebanzimanyi at gmail.com>]
>> *Sent:* Monday, May 23, 2022 11:38 AM
>> *To:* Regina Obe <lr at pcorp.us>
>> *Cc:* SAKR Mahmoud <mahmoud.sakr at ulb.be>; SCHOEMANS Maxime <
>> Maxime.Schoemans at ulb.be>
>> *Subject:* Re: [Mobilitydb-dev] Configuring for a Particular PostgreSQL
>> on Ubuntu
>>
>>
>>
>> Dear Regina
>>
>>
>>
>> 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.
>>
>>
>>
>>
>> https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49
>>
>>
>>
>> Now I can compile and use MobilityDB on PG 15 and PGIS 3.3 without any
>> problem
>>
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>> esteban at ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ psql test
>> psql (15beta1)
>> Type "help" for help.
>>
>> test=# create extension mobilitydb cascade;
>> NOTICE: installing required extension "postgis"
>> CREATE EXTENSION
>> test=# select mobilitydb_full_version();
>> mobilitydb_full_version
>> -----------------------------------------------------
>> MobilityDB 1.0.0, PostgreSQL 15beta1, PostGIS 3.3.0
>> (1 row)
>>
>> test=# select tintersects(tgeompoint '[Point(1 1)@2000-01-01, Point(3
>> 3)@2000-01-03]',
>> tgeompoint '[Point(1 3)@2000-01-01, Point(3 1)@2000-01-03]');
>> tintersects
>>
>> --------------------------------------------------------------------------------------------------------------
>> {[f at 2000-01-01 00:00:00+01, t at 2000-01-02 00:00:00+01], (f at 2000-01-02
>> 00:00:00+01, f at 2000-01-03 00:00:00+01]}
>> (1 row)
>>
>> test=#
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> However, I cannot run the MobilityDB regression tests
>>
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> esteban at ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ make test
>> Running tests...
>> Test project /home/esteban/src/MobilityDB/build
>> Start 1: build
>> 1/114 Test #1: build .............................. Passed 0.17
>> sec
>> Start 2: setup
>> 2/114 Test #2: setup .............................. Passed 2.97
>> sec
>> Start 3: create_extension
>> 3/114 Test #3: create_extension ...................***Failed 16.41
>> sec
>> Start 5: load_tables
>> Failed test dependencies: create_extension
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> despite I have modified the postgresql.conf file as required by setting
>>
>>
>>
>> shared_preload_libraries = 'postgis-3'
>>
>>
>>
>> I have the following errors in the file
>> \\wsl$\Ubuntu\home\esteban\src\MobilityDB\build\tmptest\log\create_ext.log
>>
>>
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>> ...
>>
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17652:
>> NOTICE: argument type stbox is only a shell
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17736:
>> ERROR: type box2d does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17740:
>> ERROR: type box3d does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17744:
>> ERROR: type geometry does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17748:
>> ERROR: type geography does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17768:
>> ERROR: type geometry does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17772:
>> ERROR: type geography does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17776:
>> ERROR: type geometry does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17780:
>> ERROR: type geography does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17782:
>> ERROR: type "box2d" does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17783:
>> ERROR: type "box3d" does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17784:
>> ERROR: type "geometry" does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17785:
>> ERROR: type "geography" does not exist
>> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17800:
>> NOTICE: type "geometry" is not yet defined
>>
>> ...
>>
>>
>> --------------------------------------------------------------------------------------------------------------
>>
>>
>>
>> Do you have any idea why this is the case ?
>>
>>
>>
>> Many thanks for your help
>>
>>
>>
>> Esteban
>>
>>
>>
>>
>>
>> On Sun, May 22, 2022 at 9:12 PM Regina Obe <lr at pcorp.us> wrote:
>>
>> I have multiple versions of PostgreSQL installed on my Ubuntu server.
>>
>> I can't figure out how to install against a particular version.
>>
>> I've tried this:
>>
>> cd MobilityDB
>> export PGVER=14
>> export PGPATH=/usr/lib/postgresql/${PGVER}
>> export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin
>> rm -rf build
>> mkdir build
>> cd build
>> cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..
>>
>> and I tried this:
>>
>> cd MobilityDB
>> export PGVER=14
>> export PGPATH=/usr/lib/postgresql/${PGVER}
>> export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin
>> rm -rf build
>> mkdir build
>> cd build
>> cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..
>>
>>
>> #I also explicitly tried setting the POSTGRESQL_BIN_DIR via cmake.
>> Regardless what I do it still outputs:
>>
>> -- POSTGRESQL_VERSION_MAJOR=15
>> -- POSTGRESQL_VERSION_MINOR=0
>> -- POSTGRESQL_BIN_DIR: /usr/lib/postgresql/15/bin
>> -- POSTGRESQL_INCLUDE_DIR: /usr/include/postgresql/15/server
>> -- POSTGRESQL_LIBRARIES: /usr/lib/aarch64-linux-gnu
>> -- POSTGRESQL_SHARE_DIR: /usr/share/postgresql/15
>> -- POSTGRESQL_DYNLIB_DIR: /usr/lib/postgresql/15/lib
>> -- POSTGRESQL_VERSION: 15.0
>>
>> As I mentioned in this issue, mobilitydb does not work against PostgreSQL
>> 15
>>
>> https://github.com/MobilityDB/MobilityDB/issues/218
>>
>> Thanks,
>> Regina
>>
>>
>>
>> _______________________________________________
>> Mobilitydb-dev mailing list
>> Mobilitydb-dev at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/mobilitydb-dev
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-dev/attachments/20220523/c3797586/attachment-0001.htm>
More information about the Mobilitydb-dev
mailing list