Re: [SQL] Problems invoking psql. Help please.

2002-11-26 Thread Hugh Esco
at hole, anyway. -- Hugh Esco At 02:46 PM 11/20/02 +, 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 psq

Re: [SQL] Problems invoking psql. Help please.

2002-11-20 Thread Hugh Esco
Everything in the path is executable for others. That is true for: /usr/lib/postgresql/bin and for: /usr/bin where psql is located. -- Hugh At 12:49 PM 11/20/02 +, Oliver Elphick wrote: There is something wrong with permissions here. You ought to be able, as _any_ user, to r

Re: [SQL] Problems invoking psql. Help please.

2002-11-20 Thread Hugh Esco
wxrwxrwx1 root root 10 Nov 19 20:04 pg_restore -> pg_wrapper -rwxr-xr-x1 root root 6584 Sep 11 04:30 pg_wrapper lrwxrwxrwx1 root root 10 Oct 10 16:24 psql -> pg_wrapper biko:/usr/bin$ At 02:13 AM 11/20/02 -0500, Tom Lane wrote: Hugh Esco &l

Re: [SQL] Problems invoking psql. Help please.

2002-11-20 Thread Hugh Esco
sql-client is already the newest version. 0 packages upgraded, 0 newly installed, 0 to remove and 36 not upgraded. biko:/usr/bin# So I am at a loss and still encountering the same errors as before; except that I used to be able to access the tables and objects of the model dataset created by SQL

Re: [SQL] Problems invoking psql. Help please.

2002-11-19 Thread Hugh Esco
Here are the results from reversing the arguments. hesco@biko:~$ su postgres Password: postgres@biko:/home/hesco$ cd postgres@biko:~$ cd /usr/bin postgres@biko:/usr/bin$ psql tempate1 -U postgres Could not execv /usr/lib/postgresql/bin/psql postgres@biko:/usr/bin$ psql template1 -U postgres Could

Re: [SQL] Problems invoking psql. Help please.

2002-11-19 Thread Hugh Esco
L Then you do: dpkg --purge postgresql. You can now run the first command to see if something is still installed. If some are instaled, the you remove it using again dpkg --purge. Luis Sousa Hugh Esco wrote: I have reinstalled before. I wonder though, how I ensure that I have cleanly un-install

Re: [SQL] Problems invoking psql. Help please.

2002-11-19 Thread Hugh Esco
l. You can now run the first command to see if something is still installed. If some are instaled, the you remove it using again dpkg --purge. Luis Sousa Hugh Esco wrote: I have reinstalled before. I wonder though, how I ensure that I have cleanly un-installed it first, so that I leave no re

Re: [SQL] Problems invoking psql. Help please.

2002-11-19 Thread Hugh Esco
I have reinstalled before. I wonder though, how I ensure that I have cleanly un-installed it first, so that I leave no residue from the previously botched installation around to mess things up the next time. -- Hugh Esco At 09:03 AM 11/19/02 +, Luis Sousa wrote: Tom Lane wrote: Start over

Re: [SQL] Problems invoking psql. Help please.

2002-11-18 Thread Hugh Esco
steps should be would be greatly appreciated. Thanks, -- Hugh Esco At 10:39 AM 11/17/02 +0530, Mallah wrote: try $ psql -U and post the error encountered. > Hey folks: > > I am able to consistently start and stop the postgreSQL server and to access it across our > office netwo

[SQL] Problems invoking psql. Help please.

2002-11-16 Thread Hugh Esco
tform, with postgreSQL 7.2.1 and ODBC driver 7.1.9. All help is appreciated. Thanks. -- Hugh Esco hesco@biko:~$ su postgres Password: postgres@biko:/home/hesco$ locate psql /usr/bin/psql /usr/lib/odbc/libodbcpsqlS.so /usr/share/man/man1/psql.1.gz /var/home/hesco/.psql_history postgres@biko:/home/

[SQL] Problems invoking psql. Help please.

2002-11-16 Thread Hugh Esco
iated. Thanks. -- Hugh Esco hesco@biko:~$ su postgres Password: postgres@biko:/home/hesco$ locate psql /usr/bin/psql /usr/lib/odbc/libodbcpsqlS.so /usr/share/man/man1/psql.1.gz /var/home/hesco/.psql_history postgres@biko:/home/hesco$ ./psql sh: ./psql: No such file or directory postgres@biko:/home/