When I try to run psql on 64 bit sid I get this error message:

/usr/lib/postgresql/9.4/bin/psql: symbol lookup error: /usr/lib/postgresql/9.4/bin/psql: undefined symbol: PQconninfo

I needed to run some 32 bit programs so I had to install the 32bit version. But I wonder if it added some dependencies that is causing the current problem. If its an architectural conflict then I'd like to install a 64bit psql as well, but I still need them both. Reinstalling postgresql-client doesn't change things so it seems that a 64bit is not being installed unless psql is 32bit only.

Running ` ldd /usr/lib/postgresql/9.4/bin/psql' produces:

    linux-gate.so.1 (0xf77d7000)
    libpq.so.5 => /lib/i386-linux-gnu/libpq.so.5 (0xf7782000)
    libssl.so.1.0.0 => /usr/lib/i386-linux-gnu/i686/cmov/libssl.so.1.0.0 (0xf771c000)
    libedit.so.2 => /usr/lib/i386-linux-gnu/libedit.so.2 (0xf76e4000)
    libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf7572000)
    libcrypto.so.1.0.0 => /usr/lib/i386-linux-gnu/i686/cmov/libcrypto.so.1.0.0 (0xf738d000)
    libkrb5.so.3 => /usr/lib/i386-linux-gnu/libkrb5.so.3 (0xf72b3000)
    libcom_err.so.2 => /lib/i386-linux-gnu/libcom_err.so.2 (0xf72ae000)
    libgssapi_krb5.so.2 => /usr/lib/i386-linux-gnu/libgssapi_krb5.so.2 (0xf725b000)
    libldap_r-2.4.so.2 => /usr/lib/i386-linux-gnu/libldap_r-2.4.so.2 (0xf7201000)
    libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xf71e5000)
    libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf71e0000)
    libbsd.so.0 => /lib/i386-linux-gnu/libbsd.so.0 (0xf71ce000)
    libtinfo.so.5 => /lib/i386-linux-gnu/libtinfo.so.5 (0xf71a9000)
    /lib/ld-linux.so.2 (0x565a8000)
    libk5crypto.so.3 => /usr/lib/i386-linux-gnu/libk5crypto.so.3 (0xf7177000)
    libkrb5support.so.0 => /usr/lib/i386-linux-gnu/libkrb5support.so.0 (0xf716a000)
    libkeyutils.so.1 => /lib/i386-linux-gnu/libkeyutils.so.1 (0xf7165000)
    libresolv.so.2 => /lib/i386-linux-gnu/libresolv.so.2 (0xf714e000)
    liblber-2.4.so.2 => /usr/lib/i386-linux-gnu/liblber-2.4.so.2 (0xf713d000)
    libsasl2.so.2 => /usr/lib/i386-linux-gnu/libsasl2.so.2 (0xf711f000)
    libgnutls-deb0.so.28 => /usr/lib/i386-linux-gnu/libgnutls-deb0.so.28 (0xf6fd9000)
    libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xf6fbc000)
    libp11-kit.so.0 => /usr/lib/i386-linux-gnu/libp11-kit.so.0 (0xf6f59000)
    libtasn1.so.6 => /usr/lib/i386-linux-gnu/libtasn1.so.6 (0xf6f43000)
    libnettle.so.6 => /usr/lib/i386-linux-gnu/libnettle.so.6 (0xf6f06000)
    libhogweed.so.4 => /usr/lib/i386-linux-gnu/libhogweed.so.4 (0xf6ed1000)
    libgmp.so.10 => /usr/lib/i386-linux-gnu/libgmp.so.10 (0xf6e42000)
    libffi.so.6 => /usr/lib/i386-linux-gnu/libffi.so.6 (0xf6e39000)

I am running Debian Sid, but I don't think that is the problem.

  • 1
    It's not an architecture issue. It looks like your psql is getting linked to an old version of libpq.so.5. dpkg -S /lib/i386-linux-gnu/libpq.so.5? – Craig Ringer Nov 6 '15 at 1:11
  • It seems that for some reason apt-get install postgresql-client was installing postgresql-client:i386 probably because it I needed it for some 32 bit programs. I had to use apt-get install postgresql-client-9.4 to get the 64bit version to install – vfclists Nov 8 '15 at 1:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.