Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Esteban Zimanyi
    @estebanzimanyi
    port = 5433
    and the path to the postgresql.conf file can be found for example with 
    echo $PGDATA
    Is there a "standard" way to know the port on which PostgreSQL is running using cmake that works across platforms ?
    Vicky Vergara
    @cvvergara
    SELECT *
FROM pg_settings
WHERE name = 'port';
    other method is know how things are installed. So for actions 5432 is the default, but installing a different postgres version would use 5433 so things become very dandy here:
    https://github.com/MobilityDB/MobilityDB/blob/develop/.github/workflows/pgversion.yml#L40
    Brad Hards
    @bradh
    I would suggest that the regression tests should not run on the "normal" postgres instance anyway. They should be running against a "clean" ephemeral instance that is created by the test suite, and torn down afterwards.
    Esteban Zimanyi
    @estebanzimanyi
    Dear Brad, This is indeed the case. I borrowed your efficient wording to send a message to the pgsql-hackers mailing list to know how to achieve this in Windows. https://www.postgresql.org/message-id/CAPqRbE7LHC3kyvqqGnWdEtMFgEOpbzbeR0_F6OVwXFRKuAEBag%40mail.gmail.com
    I was able to build on Windows using msys2 but I still cannot run the tests which run both on Linux and MacOS.
    ellevset
    @ellevset
    Gents, I was trying to install MobiliyDB on a fresh (minimal) Centos 8 install, but I am stuck at it not finding lwgeom, however I have installed the required packages and I am able to find the lwgeom.h file in /usr/include. Is this the right place to ask for some assistance on that?
    Brad Hards
    @bradh
    @ellevset I don't think Gents is entirely appropriate.
    What does the configure log show is actually failing?
    ellevset
    @ellevset
    Noted on the Gents-part. When I run cmake I get:
    CMake Error at CmakeLists.txt: 158 (message):
    Could not find lwgeom;
    Brad Hards
    @bradh
    I meant in the build/CMakeFiles/CMakeOutput.log (which probably appears just below that message, with a full path).
    ellevset
    @ellevset
    I am not sure what to look for, that file doesn't indicate any errors at all. lwgeom is not mentioned. It ends with 'implicit fwks: []'
    Vicky Vergara
    @cvvergara
    did you install lwgeom?
    ellevset
    @ellevset
    I believe so, as far as I understand liblwgeom was installed with postgis, I have a file /usr/include/liblwgeom.h. dnf tells me that file was installed with postgis25-devel
    Vicky Vergara
    @cvvergara
    this is how we install dependencies
    https://github.com/MobilityDB/MobilityDB/blob/develop/.github/workflows/pgversion.yml#L52
    and thenext step installs the libwgeom headers
    and btw, use develop branch
    ellevset
    @ellevset
    think I am closer now. I can find the different files, but some are installed under my pgsql-install
    I had to modify PATH to find pg_config, how can I modify my path so that the files under /usr/pgsql-12/lib are included?
    i.e., so that cmake can find them
    Vicky Vergara
    @cvvergara

    try something like this 

    PGVERSION="12"
PGBIN="/usr/lib/postgresql/${PGVERSION}/bin"
cmake  -DPOSTGRESQL_BIN=${PGBIN} ..

    Idea taken from pgrouting:
    https://github.com/pgRouting/pgrouting/blob/main/tools/developer/run.sh

    keep me posted because I havent tried that yet
    ellevset
    @ellevset
    I'll give it a try and report back
    ellevset
    @ellevset
    Nope, still no luck. I am stranded at the same error message, that it can't find lwgeom.
    Brad Hards
    @bradh
    @ellevset To get going, consider adding symlinks for the required files to whatever your library search path contains.
    ellevset
    @ellevset
    @bradh That worked like a charm. However this raises a question. it seems that cmake can use files in /usr/pgsql-12/include folder, but not /usr/pgsql-12/lib. Is that intentional?
    ellevset
    @ellevset
    almost there, got to the last point and then:
    ERROR: could not load library "/usr/pgsql-12/lib/libMobilityDB.so": /usr/pgsql-12/lib/libMobilityDB.so: undefined symbol: lwgeom_hash
    Vicky Vergara
    @cvvergara
    I get that error when postgis with another version is installed
    Normally when I try mobilitydb I remove postgis and install only postgis 2.5
    when I go back to my normal work I remove postgis 2.5 install the latest version of postgis and do what I need to do
    I will be very busy from now to the 3rd of october, but we can meet after that. I have a new computer and I havent tried mobilitydb on it, so its like starting from scratch.
    And we can work it out together.
    Brad Hards
    @bradh
    @ellevset send a pull request if you think it could be improved.
    I have no idea if it was intended - I didn't write it. Just trying to help you get going.
    ellevset
    @ellevset
    I have no other postgis to uninstall. I gave up compiling and used docker. Seems to be working swimmingly. Thanks a lot for you assistance everyone.
    tituskibiwott
    @tituskibiwott
    Hi there ,thanks for this beatiful piece of software. So i was getting this error while calling mobility db functions "/usr/lib/postgresql/12/lib/libMobilityDB-1.0.so": /usr/lib/postgresql/12/lib/libMobilityDB-1.0.so: undefined symbol: ST_Distance.
    tituskibiwott
    @tituskibiwott
    This lead me to compile and recompile to no avail.However,I noticed this appeared only on db clients such as psql,dbeaver,php pdo and psycopg but not qgis. Guess what running a postgis function such as st_astext or even select postgis_full_version() before using mobilitydb functions solves this problem. This works for me, tested on pg12 and pg13 with postgis 3.1
    tituskibiwott
    @tituskibiwott
    also works on pg11 with postgis 2.5
    Screenshot_20211028_200158.png
    Screenshot_20211028_200118.png
    Maxim Van de Wynckel
    @Maximvdw
    is MobilityDB planning to participate at FOSDEM22?
    Brad Hards
    @bradh
    Is there still a MobilityDB tutorial?
    Brad Hards
    @bradh
    Sorry for the noise. Found https://mobilitydb.com/tutorials.html
    juice8192
    @jeffdeecee:matrix.org
    [m]
    Hi all, does anyone know how Mahmoud created the visualizations on his trajectory analysis tutorial? https://www.citusdata.com/blog/authors/mahmoud-sakr/
    1_smartads.gif
    2_toyDB.jpg
    Mahmoud SAKR
    @mahmsakr
    Hi. I I used the tgeompoint::geometry to cast the temporal points into LinStringM, then followed Anita's blog to animate using the new built-in temporal controller of QGIS:
    https://anitagraser.com/category/gis/movement-data-in-gis/
    I'd however recommend that you use our 'still in development' QGIS plugin MOVE, which allows you to query MobilityDB directly in QGIS, and get animated visualizations of the result. The plugin automates the casting, and python code (plus a couple of optimizations):
    https://github.com/mschoema/move