Re: psql command
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
Reply to: