Re: Problems invoking psql. Help please.
От | Hugh Esco |
---|---|
Тема | Re: Problems invoking psql. Help please. |
Дата | |
Msg-id | 5.1.0.14.0.20021120130814.0426dad0@petra.cagreens.org обсуждение исходный текст |
Ответ на | Re: Problems invoking psql. Help please. (Oliver Elphick <olly@lfix.co.uk>) |
Список | pgsql-sql |
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)
В списке pgsql-sql по дате отправления: