Quoting Michael Long <[EMAIL PROTECTED]>: > > ./psql template1 > ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity > > Is psql linked to the proper libraries? > > --This is version 7.3.2
Below looks okay. > ldd /usr/bin/psql > libpq.so.3 => /usr/lib/libpq.so.3 (0x40015000) > libpam.so.0 => /lib/libpam.so.0 (0x4003a000) > libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40042000) > libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40072000) > libz.so.1 => /lib/libz.so.1 (0x40149000) > libreadline.so.4 => /lib/libreadline.so.4 (0x40158000) > libcrypt.so.1 => /lib/libcrypt.so.1 (0x40185000) > libresolv.so.2 => /lib/libresolv.so.2 (0x401b6000) > libnsl.so.1 => /lib/libnsl.so.1 (0x401c9000) > libdl.so.2 => /lib/libdl.so.2 (0x401de000) > libm.so.6 => /lib/libm.so.6 (0x401e1000) > libc.so.6 => /lib/libc.so.6 (0x40203000) > libncurses.so.5 => /lib/libncurses.so.5 (0x40339000) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000) > I've never installed 8.0b3, but I would guess that libpq is also found in /usr/local. Check for a second copy there and modify LD_LIBRARY_PATH and/or /etc/ld.so.conf (followed by ldconfig) on Linux to look there first. > ldd /usr/local/pgsql_8.0b3/bin/psql > libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000) > libz.so.1 => /lib/libz.so.1 (0x40039000) > libreadline.so.4 => /lib/libreadline.so.4 (0x40049000) > libcrypt.so.1 => /lib/libcrypt.so.1 (0x40076000) > libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000) > libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000) > libdl.so.2 => /lib/libdl.so.2 (0x400ce000) > libm.so.6 => /lib/libm.so.6 (0x400d1000) > libc.so.6 => /lib/libc.so.6 (0x400f4000) > libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x4022a000) > libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x4025a000) > libncurses.so.5 => /lib/libncurses.so.5 (0x40331000) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000) > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend