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 299B832A298 for ; Sun, 3 Oct 2004 07:53:58 +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 87451-08 for ; Sun, 3 Oct 2004 06:53:50 +0000 (GMT) Received: from server18.pronicsolutions.com (server18.pronicsolutions.com [66.103.131.81]) by svr1.postgresql.org (Postfix) with ESMTP id 40FBA32A28E for ; Sun, 3 Oct 2004 07:53:49 +0100 (BST) Received: from pool-129-44-186-84.bos.east.verizon.net ([129.44.186.84] helo=datalong.com) by server18.pronicsolutions.com with esmtpa (Exim 4.42) id 1CE0Ff-0000ue-FN for pgsql-admin@postgresql.org; Sun, 03 Oct 2004 02:53:47 -0400 Message-ID: <415FA1FB.9000306@datalong.com> Date: Sun, 03 Oct 2004 02:53:47 -0400 From: Michael Long User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 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> In-Reply-To: <29421.1096785225@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server18.pronicsolutions.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - datalong.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/65 X-Sequence-Number: 15058 >This looks like a 7.4 psql trying to use a pre-7.4 libpq.so. You need >to take a close look at where you've installed the different libpq >generations and how this matches up to the ldconfig search path. > >Personally I like to use rpath-style link specifications to ensure that >a particular psql generation will hook to the corresponding libpq >generation, regardless of any system-wide ldconfig settings. There are >other ways to do it, but the default Linux mechanism doesn't work very >well for this :-( > > > This is where I am getting into areas I don't really understand. I believe I have 7.3.2 installed along with 8.0b3. /usr/bin/psql -V psql (PostgreSQL) 7.3.2 /usr/local/pgsql_8.0b3/bin/psql -V psql (PostgreSQL) 8.0.0beta3 The when configuring 8.0b3 I thought that I had specified to use the rpath style link, although now that I look at the string again, maybe not :) ./configure --prefix=/usr/local/pgsql_8.0b3 --disable-rpath --with-pgport=5480 --with-perl --with-python --with-tcl --enable-thread-safety --enable-debug --enable-cassert --enable-depend --with-libraries=/lib:/usr/local/lib/python2.3/lib-dynload How do I go about sorting this out? If I rerun the istall without the --disable-rpath switch will this help?