[Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu

[Regina Obe]

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