[Qgis-user] Configuration for PostgreSQL

[Richard Duivenvoorde]

Hi,

This is just the way the Linux install's software.
I think you installed only postgres-server...

And yes you probably need a lot of header files (often residing the in the '*-dev' packages).

But have a look into:

https://github.com/qgis/QGIS/blob/master/INSTALL.md

There is a lot of info to compile it on Debian or Ubuntu, including the full apt-get line to get all the dependencies:

https://github.com/qgis/QGIS/blob/master/INSTALL.md#33-install-build-dependencies
(pick the focal line)

A question: do you really want to compile yourself? Or do you just want to run QGIS?
Because, if the last: https://qgis.org/en/site/forusers/alldownloads.html#quickstart

FYI: my line to build/install master (I'm on Debian), after you checked out from git. From withing the ~/git/qgis folder:

  # MASTER DEBUG with server and 3D in ~/bin/qgis_
  mkdir build;cd build;ccmake -GNinja -DBUILD_TESTING=FALSE -DENABLE_TESTS=OFF -DWITH_SERVER=TRUE -DWITH_3D=TRUE -DCMAKE_INSTALL_PREFIX=~/bin/qgis_/master/debug -DWITH_QWTPOLAR=OFF -DCMAKE_BUILD_TYPE=Debug -DQT5_3DEXTRA_LIBRARY=/usr/lib/x86_64-linux-gnu/libQt53DExtras.so -DWITH_GRASS=TRUE -DGRASS_PREFIX7=/usr/lib/grass78 ..

Hope this helps.

Regards,

Richard Duivenvoorde


On 5/12/22 15:09, vicentesmith via Qgis-user wrote:
> Hello,
> I'm new to QGIS and this is my first try at installing it (using cmake). My system is running Ubuntu 20.04 so I used /apt/ to install PostgreSQL. /apt/ decided that the way to go was to install all the components at the /usr/lib/postgresql/12 subdirectory, where it created 2 subdirectories bin and lib, but not include. I modified the cmake menu accordingly:
>   POSTGRESQL_PREFIX                /usr/lib/postgresql/12
>   POSTGRES_CONFIG                  /usr/lib/postgresql/12/bin/pg_config
>   POSTGRES_CONFIG_PREFER_PATH      /usr/lib/postgresql/12/bin
>   POSTGRES_INCLUDE_DIR             /usr/include/postgresql
>   POSTGRES_LIBRARY                 /usr/lib/postgresql/12/lib
> However, the configuration still fails with:
>   Could NOT find PostgreSQL (missing: PostgreSQL_LIBRARY PostgreSQL_INCLUDE_DIR)
>   Found PostgreSQL: /usr/lib/postgresql/12/lib
> This makes sense because (1) I'm not really telling it which library to load and (2) there is no /usr/include/postgresql subdirectory (although I could manually create /usr/lib/postgresql/12/include). Just for completion, the /usr/lib/postgresql/12/lib subdirectory has the following files:
> _int.so              dict_xsyn.so lo.so <http://lo.so>plpgsql.so <http://plpgsql.so>           utf8_and_euc_jp.so
> adminpack.so <http://adminpack.so>earthdistance.so <http://earthdistance.so>ltree.so <http://ltree.so>              postgres_fdw.so       utf8_and_euc_kr.so
> amcheck.so <http://amcheck.so>          euc2004_sjis2004.so moddatetime.so <http://moddatetime.so>refint.so <http://refint.so>            utf8_and_euc_tw.so
> ascii_and_mic.so     euc_cn_and_mic.so pageinspect.so <http://pageinspect.so>seg.so <http://seg.so>               utf8_and_gb18030.so
> auth_delay.so        euc_jp_and_sjis.so passwordcheck.so <http://passwordcheck.so>sepgsql.so <http://sepgsql.so>           utf8_and_gbk.so
> auto_explain.so      euc_kr_and_mic.so      pg_buffercache.so sslinfo.so <http://sslinfo.so>           utf8_and_iso8859.so
> autoinc.so <http://autoinc.so>          euc_tw_and_big5.so     pg_freespacemap.so tablefunc.so <http://tablefunc.so>         utf8_and_iso8859_1.so
> bitcode              file_fdw.so            pg_prewarm.so tcn.so <http://tcn.so>               utf8_and_johab.so
> bloom.so <http://bloom.so>fuzzystrmatch.so <http://fuzzystrmatch.so>      pg_stat_statements.so  test_decoding.so      utf8_and_sjis.so
> btree_gin.so hstore.so <http://hstore.so>             pg_trgm.so             tsm_system_rows.so    utf8_and_sjis2004.so
> btree_gist.so        insert_username.so     pg_visibility.so       tsm_system_time.so    utf8_and_uhc.so
> citext.so <http://citext.so>isn.so <http://isn.so>pgcrypto.so <http://pgcrypto.so>unaccent.so <http://unaccent.so>          utf8_and_win.so
> cube.so <http://cube.so>             latin2_and_win1250.so pgoutput.so <http://pgoutput.so>           utf8_and_ascii.so uuid-ossp.so <http://uuid-ossp.so>
> cyrillic_and_mic.so  latin_and_mic.so pgrowlocks.so <http://pgrowlocks.so>         utf8_and_big5.so
> dblink.so <http://dblink.so>libpqwalreceiver.so <http://libpqwalreceiver.so>pgstattuple.so <http://pgstattuple.so>        utf8_and_cyrillic.so
> dict_int.so llvmjit.so <http://llvmjit.so>pgxml.so <http://pgxml.so>              utf8_and_euc2004.so
> dict_snowball.so     llvmjit_types.bc       pgxs                   utf8_and_euc_cn.so
> 
> My questions are which library(ies) QGIS needs for building and if QGIS also needs any header from PostgreSQL. Thanks.
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user