Thank you Tom Lane and Oliver Elphick. Here is the latest shell dialogue.
postgres@biko:/home/hesco$ ./usr/lib/postgresql/bin/psql -d template1 sh: ./usr/lib/postgresql/bin/psql: No such file or directory postgres@biko:/home/hesco$ /usr/lib/postgresql/bin/psql -d template1 sh: /usr/lib/postgresql/bin/psql: No such file or directory postgres@biko:/home/hesco$ cd /usr/lib/postgresql/bin postgres@biko:/usr/lib/postgresql/bin$ ls -al | grep psql postgres@biko:/usr/lib/postgresql/bin$
Returned a blank prompt. My copy of psql is in /usr/bin. Is that a problem? Its where apt-get install postgresql put it. Should I move it? Someone earlier suggested building this from source, which I guess would allow me to do that. I don't know.
postgres@biko:/usr/lib/postgresql/bin$ ./usr/bin/psql -d template1 sh: ./usr/bin/psql: No such file or directory postgres@biko:/usr/lib/postgresql/bin$ /usr/bin/psql -d template1 Could not execv /usr/lib/postgresql/bin/psql postgres@biko:/usr/lib/postgresql/bin$
Same error again.
So, no. to answer Mr. Elphick's question below.postgres@biko:/usr/lib/postgresql/bin$ cd /usr/bin postgres@biko:/usr/bin$ ls -al | grep psql lrwxrwxrwx 1 root root 10 Oct 10 16:24 psql -> pg_wrapper postgres@biko:/usr/bin$ ls -al | grep pg_wrapper <snip> -rwxr-xr-x 1 root root 6584 Sep 11 04:30 pg_wrapper lrwxrwxrwx 1 root root 10 Oct 10 16:24 psql -> pg_wrapper postgres@biko:/usr/bin$
I can not run it directly.
I'm not sure what I would do with /sbin/ldconfig to let it know where /usr/lib/libpq.so.2 is located at. My attempts to run it return a blank shell prompt. I assume that Mr. Elphick's demonstration of the error generated by renaming the file shows there is no cheese down that hole, anyway.
-- Hugh Esco
At 02:46 PM 11/20/02 +0000, Oliver Elphick wrote:
On Wed, 2002-11-20 at 14:23, Hugh Esco wrote:
> Everything in the path is executable for others.
> That is true for:
> /usr/lib/postgresql/bin
> and for:
> /usr/bin
> where psql is located.
So can you run the executable directly?
/usr/lib/postgresql/bin/psql -d template1
--
Oliver Elphick [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
