[Qgis-user] Configuration for PostgreSQL

[vicentesmith]

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.soplpgsql.so utf8_and_euc_jp.so
adminpack.soearthdistance.soltree.so postgres_fdw.so utf8_and_euc_kr.so
amcheck.so euc2004_sjis2004.so moddatetime.sorefint.so utf8_and_euc_tw.so
ascii_and_mic.so euc_cn_and_mic.so pageinspect.soseg.so utf8_and_gb18030.so
auth_delay.so euc_jp_and_sjis.so passwordcheck.sosepgsql.so utf8_and_gbk.so
auto_explain.so euc_kr_and_mic.so pg_buffercache.so sslinfo.so utf8_and_iso8859.so
autoinc.so euc_tw_and_big5.so pg_freespacemap.so tablefunc.so utf8_and_iso8859_1.so
bitcode file_fdw.so pg_prewarm.so tcn.so utf8_and_johab.so
bloom.sofuzzystrmatch.so pg_stat_statements.so test_decoding.so utf8_and_sjis.so
btree_gin.so 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.soisn.sopgcrypto.sounaccent.so utf8_and_win.so
cube.so latin2_and_win1250.so pgoutput.so utf8_and_ascii.so uuid-ossp.so
cyrillic_and_mic.so latin_and_mic.so pgrowlocks.so utf8_and_big5.so
dblink.solibpqwalreceiver.sopgstattuple.so utf8_and_cyrillic.so
dict_int.so llvmjit.sopgxml.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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220512/838264fa/attachment.htm>