I can see
your PATH variable has the path to postgres bin dir, but still looks like a
environment variables issue.
Have you
double-check whether your PATH is exported. Run these at the Unix command line
to make sure:
echo
$PATH
which psql
The other
thing that I'm not sure about is one of your output lines:
-su: createdb: command not found
I was
expecting to see "-bash" instead of
"-su" as the shell name.
--
Husam
From: pgsql-admin-owner@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Iuri
Sampaio
Sent: Wednesday, September 06, 2006 10:57 PM To: pgsql-admin@xxxxxxxxxxxxxx Subject: [ADMIN] psql command The postgres commands work fine to
postgres user but it doesn’t work to a random user
account I already created the user on
postgres desktop:~# su -
postgres postgres@desktop:~$ createuser -a -d
oacsbr and set on .bashrc
LD_LIBRARY_PATH=:/usr/local/pgsql/lib:/usr/local/pgsql/lib PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/local/pgsql/bin:/usr/local/pgsql/bin But somehow I can’t run any commands
such as oacsbr@desktop:~$ createdb
- -su: createdb: command not
found oacsbr@desktop:~$ psql
-l -su: psql: command not
found oacsbr@desktop:~$ psql -l
mytestdb.dmp mytestdb -su: psql: command not
found Does anyone knows what I’ve
missed? iuri ********************************************************************** Thank you.
FADLD
Tag |