X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C971D329F92 for ; Sun, 3 Oct 2004 22:18:33 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61697-04 for ; Sun, 3 Oct 2004 21:18:30 +0000 (GMT) Received: from ext-web.kayak.kwasar.biz (s142-179-54-133.bc.hsia.telus.net [142.179.54.133]) by svr1.postgresql.org (Postfix) with ESMTP id B85FC329F90 for ; Sun, 3 Oct 2004 22:18:28 +0100 (BST) Received: from ext-web.kayak.kwasar.biz (LOCALHOST [127.0.0.1] (may be forged)) by ext-web.kayak.kwasar.biz (8.12.10/8.12.10) with ESMTP id i93LINMF029567; Sun, 3 Oct 2004 14:18:23 -0700 Received: (from apache@localhost) by ext-web.kayak.kwasar.biz (8.12.10/8.12.10/Submit) id i93LIN3I029566; Sun, 3 Oct 2004 14:18:23 -0700 Received: from int-proxy.kwasar.biz (int-proxy.kwasar.biz [192.168.1.106]) by webmail.kwasar.biz (IMP) with HTTP for ; Sun, 3 Oct 2004 14:18:22 -0700 Message-ID: <1096838302.41606c9eee381@webmail.kwasar.biz> Date: Sun, 3 Oct 2004 14:18:22 -0700 From: dan@kwasar.biz To: Michael Long Cc: pgsql-admin@postgresql.org Subject: Re: Users and multiple server environment References: <415F87D7.5000800@datalong.com> <28880.1096780739@sss.pgh.pa.us> <415F8EC5.9040504@datalong.com> <415F9A9F.6090500@datalong.com> <29421.1096785225@sss.pgh.pa.us> <415FA1FB.9000306@datalong.com> <3071.1096822055@sss.pgh.pa.us> <41606106.2080006@datalong.com> In-Reply-To: <41606106.2080006@datalong.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 192.168.1.106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200410/76 X-Sequence-Number: 15069 Quoting Michael Long : > > ./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 majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.