Originally posted by dsgdevil
command not found?
What part of the following os generating that error message?
Welcome to psql ...
postgres=# alter user smithj with password 'jabberwocky';
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
defined in their environment. Check that and let me know what happens then.