/usr/bin/ld: cannot find -lpq

Dr_Death_UAE · 03-16-2006, 01:22 AM

hi,

I was installing a software and this error message showup:

/usr/bin/ld: cannot find -lpq
collect2: ld returned 1 exit status
make: *** [hydra] Error 1

i dont know what "lpq" stand for, i search it in http://rpm.pbone.net as libpq, its gave me "postgresql-8.0.7", but its not the missing one.

sorry for my English

Dr_Death_UAE · 03-16-2006, 01:26 AM

i solve the problem, the missing file was "postgresql-devel-8.0.7-1"

bc8o8 · 03-16-2006, 02:46 AM

When you see -lpq, its telling the compiler (probably gcc or g++) to load the pq libraries (which will be named libpq-xxxx.so). So if you think the appropriate packages are installed, then a locate libpq* should come up with some results. If it does, make sure the appropriate directories are in your library search path ( $LD_LIBRARY_PATH ) by either adding it manually, in a login script (.bashrc or similar) or adding it to /etc/ld.so.conf and running ldconfig. If no results come up in the "locate" then you either need to update your search database (updatedb) or install the appropriate packages.

Nukles · 06-19-2014, 11:18 AM

Hi all, I make this ooold thread alive again as I have the same issue. My system is a POWER7+ Server with SLES11 SP3.

When trying to install psycopg2 with easy_install, that is when doing:

Code:

easy_install psycopg2

I receive the following error:

Code:

/usr/lib64/gcc/powerpc64-suse-linux/4.3/../../../../powerpc64-suse-linux/bin/ld: cannot find -lpq

However, I do have postgresql-devel package installed:

Code:

root@xxx> /usr/bin# rpm -qa |grep postgresql
postgresql91-docs-9.1.9-0.3.1
postgresql91-9.1.9-0.3.1
postgresql91-server-9.1.9-0.3.1
postgresql91-contrib-9.1.9-0.3.1
postgresql-init-9.1-0.6.14.1
postgresql-devel-8.3.11-0.1.1
postgresql-8.3.23-0.4.1

I do have libpq:

Code:

root@xxx> /usr/bin# locate libpq                                 [18:12]
/usr/include/pgsql/internal/libpq
/usr/include/pgsql/internal/libpq-int.h
/usr/include/pgsql/internal/libpq/pqcomm.h
/usr/include/pgsql/libpq
/usr/include/pgsql/libpq-fe.h
/usr/include/pgsql/libpq/libpq-fs.h
/usr/include/pgsql/server/libpq
/usr/include/pgsql/server/libpq/auth.h
/usr/include/pgsql/server/libpq/be-fsstubs.h
/usr/include/pgsql/server/libpq/crypt.h
/usr/include/pgsql/server/libpq/hba.h
/usr/include/pgsql/server/libpq/ip.h
/usr/include/pgsql/server/libpq/libpq-be.h
/usr/include/pgsql/server/libpq/libpq-fs.h
/usr/include/pgsql/server/libpq/libpq.h
/usr/include/pgsql/server/libpq/md5.h
/usr/include/pgsql/server/libpq/pqcomm.h
/usr/include/pgsql/server/libpq/pqformat.h
/usr/include/pgsql/server/libpq/pqsignal.h
/usr/lib/libpq.so.5
/usr/lib/libpq.so.5.4
/usr/lib/postgresql91/lib64/libpqwalreceiver.so
/usr/lib64/libpq.so
/usr/lib64/libpq.so.5
/usr/lib64/libpq.so.5.4
/usr/share/doc/packages/postgresql91/html/install-windows-libpq.html
/usr/share/doc/packages/postgresql91/html/libpq-async.html
/usr/share/doc/packages/postgresql91/html/libpq-build.html
/usr/share/doc/packages/postgresql91/html/libpq-cancel.html
/usr/share/doc/packages/postgresql91/html/libpq-connect.html
/usr/share/doc/packages/postgresql91/html/libpq-control.html
/usr/share/doc/packages/postgresql91/html/libpq-copy.html
/usr/share/doc/packages/postgresql91/html/libpq-envars.html
/usr/share/doc/packages/postgresql91/html/libpq-events.html
/usr/share/doc/packages/postgresql91/html/libpq-example.html
/usr/share/doc/packages/postgresql91/html/libpq-exec.html
/usr/share/doc/packages/postgresql91/html/libpq-fastpath.html
/usr/share/doc/packages/postgresql91/html/libpq-ldap.html
/usr/share/doc/packages/postgresql91/html/libpq-misc.html
/usr/share/doc/packages/postgresql91/html/libpq-notice-processing.html
/usr/share/doc/packages/postgresql91/html/libpq-notify.html
/usr/share/doc/packages/postgresql91/html/libpq-pgpass.html
/usr/share/doc/packages/postgresql91/html/libpq-pgservice.html
/usr/share/doc/packages/postgresql91/html/libpq-ssl.html
/usr/share/doc/packages/postgresql91/html/libpq-status.html
/usr/share/doc/packages/postgresql91/html/libpq-threading.html
/usr/share/doc/packages/postgresql91/html/libpq.html
/usr/share/locale/cs/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/de/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/es/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/fr/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/it/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/ja/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/ko/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/pl/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/pt_BR/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/ru/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/sv/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/tr/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/zh_CN/LC_MESSAGES/libpq5-9.1.mo
/usr/share/locale/zh_TW/LC_MESSAGES/libpq5-9.1.mo

I did define several directories in the LD_LIBRARY_PATH variable, but none seems to work: how do I identify the correct path?

Do you have any idea of why easy_install is looking at that complicated directory path? (/usr/lib64/gcc/powerpc64-suse-linux/4.3/../../../../powerpc64-suse-linux/bin/ld)

Any help appreciated! Thanks!