Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOAdO-0007mb-Nb for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2013 17:41:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UOAdL-0003hC-Os for pgsql-admin@arkaria.postgresql.org; Fri, 05 Apr 2013 17:41:03 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOAdK-0003h7-Q8 for pgsql-admin@postgresql.org; Fri, 05 Apr 2013 17:41:03 +0000 Received: from mail9.gmhwh.org ([216.49.178.72]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOAdF-0001uU-QT for pgsql-admin@postgresql.org; Fri, 05 Apr 2013 17:41:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=ldschurch.org; h=date : from : to : cc : subject : message-id : reply-to : references : mime-version : content-type : in-reply-to; s=nov2012; bh=MhxqF9w778Zh/j/GYSNXq0VnV7U53m04daQNn8fb9jQ=; b=gWInbyqO/hgcu78f3kHbqKj2wmceEAqlzwhZUvmO+QZP5nKZfpEpjIA88PCZAQzmJRWM vHm8qM89rxQHMkCktkru1lG0VpJNaosnhQic/4cHoT3ZthAjaDqITEdeyuC4qFF+Rnrt cRFFigajXJYvtYtbkxFtmN18CFU16vNjhIReEBQaDPVVsMn/MfHxBGVkSw7/XTN2huxd 1Rh7gC6P68HPUjYJmCwgfwgjDX7zM7tJSpIdnFNkpelBIitlmS1l0cY8Rfnjg79l8dlE wZ1Gz8AEcfx4vcd7QlogE1zC6ck+jX/cozOWIrfTvlJy7Rq3mBnI4yXomCgVIKi3S/n0 kA== Received: from W12119.ldschurch.org ([10.97.50.119]) by mail9.gmhwh.org (8.14.5/8.14.5) with ESMTP id r35Herwf027741 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NOT); Fri, 5 Apr 2013 11:40:53 -0600 Received: from chqpvuw1165.ldschurch.org (10.97.70.85) by W12119.ldschurch.org (10.97.50.119) with Microsoft SMTP Server (TLS) id 14.1.355.2; Fri, 5 Apr 2013 11:40:53 -0600 Received: from gr8.dev (10.98.250.245) by mail.ldschurch.org (10.97.70.85) with Microsoft SMTP Server (TLS) id 14.1.355.2; Fri, 5 Apr 2013 11:40:53 -0600 Date: Fri, 5 Apr 2013 11:40:47 -0600 From: Bruce Hunsaker To: Tom Lane CC: "Campbell, Lance" , "pgsql-admin@postgresql.org" Subject: Re: Trouble connecting locally after 9.2.4 upgrade Message-ID: <20130405174047.GA3355@gr8.dev> Reply-To: References: <9736.1365105359@sss.pgh.pa.us> <11703.1365110407@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Disposition: inline In-Reply-To: <11703.1365110407@sss.pgh.pa.us> User-Agent: Mutt/1.5.21 (2010-09-15) X-Originating-IP: [10.98.250.245] X-Disclaimer: True X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.10.8626, 1.0.431, 0.0.0000 definitions=2013-04-05_04:2013-04-05, 2013-04-05, 1970-01-01 signatures=0 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On 04 Apr 13 17 20, Tom Lane wrote: > "Campbell, Lance" writes: > > I figured it all out. When I ran the configuration script I told it > > to put the code in pgsql-9.2.4. Then after the code installed I > > moved it to pgsql-9.2. Then the install could not find the proper > > libraries. So it used the system one. I reinstalled but this time > > with the target directory of pgsql-9.2. It worked fine. I don't > > need the environment variable LD_LIBRARY_PATH now. > > Hah. Right, because configure would have set things up to build psql > etc with rpaths pointing to the lib directory under the installation > directory it was told to use. So it'd work until you moved the lib > directory. > > Moral: be careful about relocating installed trees. That's why I like to use LDFLAGS="-Wl,-rpath,'$ORIGIN/../lib'" when I build. It makes the install tree relocatable. -- Bruce Hunsaker NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin