Thank you so much, Mallah, Tomasz Myrta, Luis Sousa, Achilleus Mantzios, Tom Lane, Bill Eaton and Oliver Elphick.
I have chmod 755 my readpgenv file, and then copied the shell script suggested by Tomasz Myrta into that file, yielding these results:
biko:/usr/lib/postgresql/bin# cd /usr/bin
biko:/usr/bin# ./psql -U postgres
No database specified
biko:/usr/bin# ./psql -U postgres template1
/usr/lib/postgresql/bin/readpgenv: ./etc/postgresql/postgresql.env: No such file
or directory
How should that file read?
Could not execv /usr/lib/postgresql/bin/psql
Then I copied the readpgenv shell script to readpgenv.bu, and deleted all the text from the readpgenv script, leaving an empty file with 755 permissions.
biko:/usr/bin# ./psql -U postgres template1 Could not execv /usr/lib/postgresql/bin/psql
tried a different database (which exists according to pgAdmin II).
biko:/usr/bin# ./psql -U postgres ggp_test2 Could not execv /usr/lib/postgresql/bin/psql
Then I changed user from root to postgres, under which this database had been created:
biko:/usr/bin# su postgres biko:/usr/bin$ ./psql -U postgres ggp_test2 Could not execv /usr/lib/postgresql/bin/psql biko:/usr/bin$
That's the current crop of errors following the advice to date. As postgres, here is how my .profile in that user's home directory reads:
biko:/usr/bin$ whoami
postgres
biko:/usr/bin$ cd
biko:~$ pwd
/var/lib/postgres
biko:~$ ls -al
total 20
drwx------ 3 postgres postgres 4096 Oct 15 08:42 .
drwxr-xr-x 20 root root 4096 Oct 14 06:43 ..
-rw------- 1 postgres postgres 1343 Nov 16 17:45 .bash_history
-rw-r--r-- 1 postgres postgres 175 Oct 14 06:43 .profile
drwx------ 7 postgres postgres 4096 Nov 18 18:55 data
biko:~$ cat .profile
. /etc/postgresql/postmaster.conf
PATH=/bin:/usr/bin:/usr/lib/postgresql/bin
PGDATA=${POSTGRES_DATA:-/var/lib/postgres/data}
PGLIB=/usr/lib/postgresql/lib
export PGLIB PGDATA
biko:~$
Any ideas on what my next steps should be would be greatly appreciated.
Thanks,
-- Hugh Esco
At 10:39 AM 11/17/02 +0530, Mallah wrote:
try
$ psql -U <username> <databasename>
and post the error encountered.
<and I had previously written, in part:>
> Hey folks:
>
> I am able to consistently start and stop the postgreSQL server and to access it across our
> office network with pgAdmin II. I have had no luck invoking the psql command line prompt,
> from where I can enter queries and start to surmount the learning curve from background with
> mySQL to my next step with postgreSQL. Can anyone help me figure out, please, what this is
> about and what I can do about it?
>
> I am operating on a Debian Woody Platform,
> with postgreSQL 7.2.1 and ODBC driver 7.1.9.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
