db_postgres build failed on ubuntu 16.04

[dugugang123]

CC (gcc) [M db_postgres.so] pg_cmd.o
CC (gcc) [M db_postgres.so] km_res.o
CC (gcc) [M db_postgres.so] pg_uri.o
CC (gcc) [M db_postgres.so] pg_fld.o
make[2]: 'libsrdb2.so.1.0' is up to date.
make[2]: 'libsrdb1.so.1.0' is up to date.
LD (gcc) [M db_postgres.so] db_postgres.so
/usr/bin/ld: 当搜索用于 /usr/lib/x86_64-linux-gnu/libpq.so 时跳过不兼容的 -lpq
/usr/bin/ld: 当搜索用于 /usr/lib/x86_64-linux-gnu/libpq.a 时跳过不兼容的 -lpq
/usr/bin/ld: 找不到 -lpq
/usr/bin/ld: 当搜索用于 /usr/lib/x86_64-linux-gnu/libc.so 时跳过不兼容的 -lc
/usr/bin/ld: 当搜索用于 /usr/lib/x86_64-linux-gnu/libc.a 时跳过不兼容的 -lc
collect2: error: ld returned 1 exit status
../../Makefile.rules:188: recipe for target 'db_postgres.so' failed
make[1]: *** [db_postgres.so] Error 1
Makefile:511: recipe for target 'modules' failed
make: *** [modules] Error 1

[linuxmaniac]

I would say it does. From https://kamailio.sipwise.com/job/kamailiodev-nightly-binaries/architecture=amd64,distribution=xenial,label=slave/672/consoleText

/usr/bin/make -C src/ every-module 
make[2]: Entering directory '/tmp/buildd/kamailio-5.0.0~dev8+0~20161214005444.673+xenial/src'
CC (gcc) [M db_postgres.so]		km_val.o
CC (gcc) [M db_postgres.so]		db_postgres.o
CC (gcc) [M db_postgres.so]		pg_oid.o
CC (gcc) [M db_postgres.so]		pg_fld.o
CC (gcc) [M db_postgres.so]		pg_con.o
CC (gcc) [M db_postgres.so]		pg_mod.o
CC (gcc) [M db_postgres.so]		pg_res.o
CC (gcc) [M db_postgres.so]		pg_sql.o
CC (gcc) [M db_postgres.so]		km_pg_con.o
CC (gcc) [M db_postgres.so]		km_dbase.o
CC (gcc) [M db_postgres.so]		pg_cmd.o
CC (gcc) [M db_postgres.so]		km_res.o
CC (gcc) [M db_postgres.so]		pg_uri.o
make[4]: 'libsrdb2.so.1.0' is up to date.
make[4]: 'libsrdb1.so.1.0' is up to date.
LD (gcc) [M db_postgres.so]		db_postgres.so

[miconda]

I just tested myself and also works here, so I guess it is something specific to your environment. Can you try with a fresh clone of kamailio?

kamailio-dev$ make modules modules=src/modules/db_postgres
make -C src/ modules modules=modules/db_postgres
make[1]: Entering directory '/home/milano/work/sip/esr/kamailio-dev/src'
CC (gcc) [M db_postgres.so]		km_dbase.o
CC (gcc) [M db_postgres.so]		km_val.o
CC (gcc) [M db_postgres.so]		pg_oid.o
CC (gcc) [M db_postgres.so]		pg_fld.o
CC (gcc) [M db_postgres.so]		pg_con.o
CC (gcc) [M db_postgres.so]		pg_mod.o
CC (gcc) [M db_postgres.so]		km_res.o
CC (gcc) [M db_postgres.so]		pg_uri.o
CC (gcc) [M db_postgres.so]		pg_sql.o
CC (gcc) [M db_postgres.so]		pg_res.o
CC (gcc) [M db_postgres.so]		km_pg_con.o
CC (gcc) [M db_postgres.so]		db_postgres.o
CC (gcc) [M db_postgres.so]		pg_cmd.o
CC (gcc) [L libsrdb2.so.1.0]		db_fld.o
CC (gcc) [L libsrdb2.so.1.0]		db_con.o
CC (gcc) [L libsrdb2.so.1.0]		db_res.o
CC (gcc) [L libsrdb2.so.1.0]		db_rec.o
CC (gcc) [L libsrdb2.so.1.0]		db_drv.o
CC (gcc) [L libsrdb2.so.1.0]		db_gen.o
CC (gcc) [L libsrdb2.so.1.0]		db_pool.o
CC (gcc) [L libsrdb2.so.1.0]		db_cmd.o
CC (gcc) [L libsrdb2.so.1.0]		db.o
CC (gcc) [L libsrdb2.so.1.0]		db_uri.o
CC (gcc) [L libsrdb2.so.1.0]		db_ctx.o
LD (gcc) [L libsrdb2.so.1.0]		libsrdb2.so.1.0
CC (gcc) [L libsrdb1.so.1.0]		db_query.o
CC (gcc) [L libsrdb1.so.1.0]		db_id.o
CC (gcc) [L libsrdb1.so.1.0]		db.o
CC (gcc) [L libsrdb1.so.1.0]		db_row.o
CC (gcc) [L libsrdb1.so.1.0]		db_res.o
CC (gcc) [L libsrdb1.so.1.0]		db_pool.o
CC (gcc) [L libsrdb1.so.1.0]		db_ut.o
CC (gcc) [L libsrdb1.so.1.0]		db_val.o
LD (gcc) [L libsrdb1.so.1.0]		libsrdb1.so.1.0
LD (gcc) [M db_postgres.so]		db_postgres.so
make[1]: Leaving directory '/home/milano/work/sip/esr/kamailio-dev/src'

[linuxmaniac]

Works for us. Reopen if you have more info.