Re: psql command - Mailing list pgsql-admin

I forgot to contextualize,

env | grep PATH :

oacsbr@desktop:~$ env | grep PATH

PATH=/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games

Funny thing, speaking about full paths... there is no psql command in "/usr/bin/"

oacsbr@desktop:~$ ls -l /usr/bin/psql

ls: /usr/bin/psql: No such file or directory

I installed postgresql 8.1 from tarball-source and followed those steps:

http://openacs.org/doc/current/postgres.html

I didn't use apt-get install

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 -E UNICODE mytestdb

-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