Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E650B475E42 for ; Wed, 20 Nov 2002 12:00:50 -0500 (EST) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id 35C36475E31 for ; Wed, 20 Nov 2002 12:00:48 -0500 (EST) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 18EYDc-000Fit-0X; Wed, 20 Nov 2002 17:00:52 +0000 Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.36 #1 (Debian)) id 18EYDc-0007Di-00; Wed, 20 Nov 2002 17:00:52 +0000 Subject: Re: Problems invoking psql. Help please. From: Oliver Elphick To: Tom Lane Cc: Hugh Esco , pgsql-sql@postgresql.org In-Reply-To: <1347.1037804633@sss.pgh.pa.us> References: <29178.1037776397@sss.pgh.pa.us> <5.1.0.14.0.20021120015333.04220570@petra.cagreens.org> <5.1.0.14.0.20021120015333.04220570@petra.cagreens.org> <5.1.0.14.0.20021120075927.042606b0@petra.cagreens.org> <1037803514.24840.20.camel@linda> <1347.1037804633@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 20 Nov 2002 17:00:51 +0000 Message-Id: <1037811652.24961.24.camel@linda> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/314 X-Sequence-Number: 10456 On Wed, 2002-11-20 at 15:03, Tom Lane wrote: > Oliver Elphick writes: > > execv() is a system call to run another executable in place of the > > current process. If the other executable is not present, or does not > > have permissions, you will not be able to run it. Find out why. > > Aside from access problems for the executable itself, it could be that > there's a shared-library access problem. Perhaps ldconfig needs to be > told where libpq.so is? It's not the error message you would get for that: olly@linda$ sudo mv /usr/lib/libpq.so.2 /usr/lib/libpq.so.2.bak Password: olly@linda$ psql -d bray /usr/lib/postgresql/bin/psql: error while loading shared libraries: libpq.so.2: cannot open shared object file: No such file or directory -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If my people, which are called by my name, shall humble themselves, and pray, and seek my face, and turn from their wicked ways; then will I hear from heaven, and will forgive their sin, and will heal their land." II Chronicles 7:14