Re: Problems invoking psql. Help please.

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.

>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$

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.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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)