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 > > [EMAIL PROTECTED]:~$ 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 > > [EMAIL PROTECTED]:~$ createdb -E UNICODE mytestdb > > -su: createdb: command not found > > [EMAIL PROTECTED]:~$ psql -l > > -su: psql: command not found > > [EMAIL PROTECTED]:~$ 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 <[EMAIL PROTECTED]> KD5SZ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]