<div style="font-family: arial; font-size: 14px;"><span>Hello,</span><div>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 <i>apt</i> to install PostgreSQL. <i>apt</i> 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:</div><div><span style="font-size: 9pt;"> POSTGRESQL_PREFIX                /usr/lib/postgresql/12</span></div><div><span style="font-size: 9pt;"> POSTGRES_CONFIG                  /usr/lib/postgresql/12/bin/pg_config</span></div><div><span style="font-size: 9pt;"> POSTGRES_CONFIG_PREFER_PATH      /usr/lib/postgresql/12/bin</span></div><div><span style="font-size: 9pt;"> POSTGRES_INCLUDE_DIR             /usr/include/postgresql</span></div><div><span style="font-size: 9pt;"> POSTGRES_LIBRARY                 /usr/lib/postgresql/12/lib</span></div><div><span>However, the configuration still fails with: </span></div><div><span style="font-size: 9pt;"> Could NOT find PostgreSQL (missing: PostgreSQL_LIBRARY PostgreSQL_INCLUDE_DIR)</span></div><div><span style="font-size: 9pt;"> Found PostgreSQL: /usr/lib/postgresql/12/lib</span></div><div><span>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:</span></div><div><span style="font-size: 9pt;">_int.so              dict_xsyn.so           </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://lo.so"><span style="font-size: 9pt;">lo.so</span></a></span><span style="font-size: 9pt;">                  </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://plpgsql.so"><span style="font-size: 9pt;">plpgsql.so</span></a></span><span style="font-size: 9pt;">            utf8_and_euc_jp.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://adminpack.so"><span style="font-size: 9pt;">adminpack.so</span></a></span><span style="font-size: 9pt;">         </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://earthdistance.so"><span style="font-size: 9pt;">earthdistance.so</span></a></span><span style="font-size: 9pt;">       </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://ltree.so"><span style="font-size: 9pt;">ltree.so</span></a></span><span style="font-size: 9pt;">               postgres_fdw.so       utf8_and_euc_kr.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://amcheck.so"><span style="font-size: 9pt;">amcheck.so</span></a></span><span style="font-size: 9pt;">           euc2004_sjis2004.so    </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://moddatetime.so"><span style="font-size: 9pt;">moddatetime.so</span></a></span><span style="font-size: 9pt;">         </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://refint.so"><span style="font-size: 9pt;">refint.so</span></a></span><span style="font-size: 9pt;">             utf8_and_euc_tw.so</span></div><div><span style="font-size: 9pt;">ascii_and_mic.so     euc_cn_and_mic.so      </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pageinspect.so"><span style="font-size: 9pt;">pageinspect.so</span></a></span><span style="font-size: 9pt;">         </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://seg.so"><span style="font-size: 9pt;">seg.so</span></a></span><span style="font-size: 9pt;">                utf8_and_gb18030.so</span></div><div><span style="font-size: 9pt;">auth_delay.so        euc_jp_and_sjis.so     </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://passwordcheck.so"><span style="font-size: 9pt;">passwordcheck.so</span></a></span><span style="font-size: 9pt;">       </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://sepgsql.so"><span style="font-size: 9pt;">sepgsql.so</span></a></span><span style="font-size: 9pt;">            utf8_and_gbk.so</span></div><div><span style="font-size: 9pt;">auto_explain.so      euc_kr_and_mic.so      pg_buffercache.so      </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://sslinfo.so"><span style="font-size: 9pt;">sslinfo.so</span></a></span><span style="font-size: 9pt;">            utf8_and_iso8859.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://autoinc.so"><span style="font-size: 9pt;">autoinc.so</span></a></span><span style="font-size: 9pt;">           euc_tw_and_big5.so     pg_freespacemap.so     </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://tablefunc.so"><span style="font-size: 9pt;">tablefunc.so</span></a></span><span style="font-size: 9pt;">          utf8_and_iso8859_1.so</span></div><div><span style="font-size: 9pt;">bitcode              file_fdw.so            pg_prewarm.so          </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://tcn.so"><span style="font-size: 9pt;">tcn.so</span></a></span><span style="font-size: 9pt;">                utf8_and_johab.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://bloom.so"><span style="font-size: 9pt;">bloom.so</span></a></span><span style="font-size: 9pt;">             </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://fuzzystrmatch.so"><span style="font-size: 9pt;">fuzzystrmatch.so</span></a></span><span style="font-size: 9pt;">       pg_stat_statements.so  test_decoding.so      utf8_and_sjis.so</span></div><div><span style="font-size: 9pt;">btree_gin.so         </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://hstore.so"><span style="font-size: 9pt;">hstore.so</span></a></span><span style="font-size: 9pt;">              pg_trgm.so             tsm_system_rows.so    utf8_and_sjis2004.so</span></div><div><span style="font-size: 9pt;">btree_gist.so        insert_username.so     pg_visibility.so       tsm_system_time.so    utf8_and_uhc.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://citext.so"><span style="font-size: 9pt;">citext.so</span></a></span><span style="font-size: 9pt;">            </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://isn.so"><span style="font-size: 9pt;">isn.so</span></a></span><span style="font-size: 9pt;">                 </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pgcrypto.so"><span style="font-size: 9pt;">pgcrypto.so</span></a></span><span style="font-size: 9pt;">            </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://unaccent.so"><span style="font-size: 9pt;">unaccent.so</span></a></span><span style="font-size: 9pt;">           utf8_and_win.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://cube.so"><span style="font-size: 9pt;">cube.so</span></a></span><span style="font-size: 9pt;">              latin2_and_win1250.so  </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pgoutput.so"><span style="font-size: 9pt;">pgoutput.so</span></a></span><span style="font-size: 9pt;">            utf8_and_ascii.so     </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://uuid-ossp.so"><span style="font-size: 9pt;">uuid-ossp.so</span></a></span></div><div><span style="font-size: 9pt;">cyrillic_and_mic.so  latin_and_mic.so       </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pgrowlocks.so"><span style="font-size: 9pt;">pgrowlocks.so</span></a></span><span style="font-size: 9pt;">          utf8_and_big5.so</span></div><div><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://dblink.so"><span style="font-size: 9pt;">dblink.so</span></a></span><span style="font-size: 9pt;">            </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://libpqwalreceiver.so"><span style="font-size: 9pt;">libpqwalreceiver.so</span></a></span><span style="font-size: 9pt;">    </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pgstattuple.so"><span style="font-size: 9pt;">pgstattuple.so</span></a></span><span style="font-size: 9pt;">         utf8_and_cyrillic.so</span></div><div><span style="font-size: 9pt;">dict_int.so          </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://llvmjit.so"><span style="font-size: 9pt;">llvmjit.so</span></a></span><span style="font-size: 9pt;">             </span><span><a target="_blank" rel="noreferrer nofollow noopener" href="http://pgxml.so"><span style="font-size: 9pt;">pgxml.so</span></a></span><span style="font-size: 9pt;">               utf8_and_euc2004.so</span></div><div><span style="font-size: 9pt;">dict_snowball.so     llvmjit_types.bc       pgxs                   utf8_and_euc_cn.so</span></div><span><div style="font-family: arial; font-size: 14px;"><span><br></span></div>My questions are which library(ies) QGIS needs for building and if QGIS also needs any header from PostgreSQL. Thanks.</span><br></div><div class="protonmail_signature_block" style="font-family: arial; font-size: 14px;">
</div>