Quote:
Originally posted by dsgdevil
command not found?
|
What part of the following os generating that error message?
$ psql
Welcome to psql ...
postgres=# alter user smithj with password 'jabberwocky';
ALTER USER
postgres=# \q
$
If psql cannot be found then it sounds like the PostgreSQL binaries are not in your PATH. And possibly the LD_LIBRARY_PATH environment variable is missing the location of the PG libraries.
I have everything installed under /opt/postgresql so users that need to use psql need to have
export PATH=${PATH}:/opt/postgresql/bin
export LD_LIBRARY_PATH=/opt/postgresql/lib
defined in their environment. Check that and let me know what happens then.
Cheers...
Rick