RE: psql command
>
> '>'> 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
> '>'
>
>
>
>
-----Original Message-----
From: Jeff D [mailto:fixedored@gmail.com]
Sent: Tuesday, September 05, 2006 8:19 PM
To: debian-user@lists.debian.org
Subject: 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
>
--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact
listmaster@lists.debian.org
-----Original Message-----
From: Jeff D [mailto:fixedored@gmail.com]
Sent: Tuesday, September 05, 2006 8:19 PM
To: debian-user@lists.debian.org
Subject: Re: psql command
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 ?
--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact
listmaster@lists.debian.org
Yes I am
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
let's contextualize...
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
Iuri
Reply to: