Re: Problems invoking psql. Help please.

Thank you Tom Lane and Oliver Elphick.

Here is the latest shell dialogue.

>postgres(at)biko:/home/hesco$ ./usr/lib/postgresql/bin/psql -d template1
>sh: ./usr/lib/postgresql/bin/psql: No such file or directory
>postgres(at)biko:/home/hesco$ /usr/lib/postgresql/bin/psql -d template1
>sh: /usr/lib/postgresql/bin/psql: No such file or directory
>postgres(at)biko:/home/hesco$ cd /usr/lib/postgresql/bin
>postgres(at)biko:/usr/lib/postgresql/bin$ ls -al | grep psql
>postgres(at)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(at)biko:/usr/lib/postgresql/bin$ ./usr/bin/psql -d template1
>sh: ./usr/bin/psql: No such file or directory
>postgres(at)biko:/usr/lib/postgresql/bin$ /usr/bin/psql -d template1
>Could not execv /usr/lib/postgresql/bin/psql
>postgres(at)biko:/usr/lib/postgresql/bin$

Same error again.

>postgres(at)biko:/usr/lib/postgresql/bin$ cd /usr/bin
>postgres(at)biko:/usr/bin$ ls -al | grep psql
>lrwxrwxrwx 1 root root 10 Oct 10 16:24 psql -> pg_wrapper
>postgres(at)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(at)biko:/usr/bin$

So, no. to answer Mr. Elphick's question below.
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 Oliver(dot)Elphick(at)lfix(dot)co(dot)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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)