Re: psql command

[Bud Rogers <budr@netride.net>]

On Monday 04 September 2006 11:47, Iuri Sampaio wrote:
> The postgres commands doesn't work to an 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/b in:/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?

A small thing that I have overlooked more than once.  You have to 
run .bashrc after an edit, either by logging out and back in, or by 
sourcing it on the command line.

~$   .   .bashrc


-- 
Bud Rogers	<budr@netride.net>	 KD5SZ