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

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

Shouldn't these environmental variables handle what the readpgenv file is
supposed to do for me?

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.