[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: psql command



Iuri Sampaio wrote:
Bud
Thanks for remind me that, but I already did that, even boot over again the
machine, turn off and turn on. Neither those worked out

iuri


'>'> 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
 '>'
 '>'
 '>'
'>'-- '>'To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org '>'with a subject of "unsubscribe". Trouble? Contact
listmaster@lists.debian.org
 '>'



are you exporting PATH in your bashrc ?
what does env | grep PATH   report?
what about using the full path to the commands?
/usr/bin/psql ?




Reply to: