Re: psql command

2006-09-05 Thread Jan Dinger 

Jeff D wrote:

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]
 '>'



  


-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 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






  


ah ok, since you installed from a tarball .. you will probably have to 
add

/usr/local/pgsql/bin to your PATH ..


Hi, there is al installation guide what i wrote. Its a LAMPP-System but 
PostgreSQL, have a own Part:

http://www.devroom.org/index.php?article_id=10

I hope this can help.


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

RE: psql command

2006-09-05 Thread Iuri Sampaio 

>
> '>'> 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]
>  '>'
>
>
>
>   

-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 
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 [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]




-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 
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 [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]





Yes I am

env | grep PATH :

[EMAIL PROTECTED]:~$ 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/"

[EMAIL PROTECTED]:~$ 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










-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: psql command

2006-09-05 Thread Jeff D 

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]
 '>'



  



-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 
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






  


ah ok, since you installed from a tarball .. you will probably have to add
/usr/local/pgsql/bin to your PATH ..


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

RE: psql command

2006-09-05 Thread Iuri Sampaio 
>
> '>'> 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]
>  '>'
>
>
>
>   

-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 
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 [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]




-Original Message-
From: Jeff D [mailto:[EMAIL PROTECTED] 
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 [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]





Yes I am

env | grep PATH :

[EMAIL PROTECTED]:~$ 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/"

[EMAIL PROTECTED]:~$ 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










-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: psql command

2006-09-05 Thread Jeff D 

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
 '>'>
 '>'> [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]
 '>'



  

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 [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

RE: Re: psql command

2006-09-05 Thread Iuri Sampaio 
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
 '>'>
 '>'> [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]
 '>'



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

FW: Re: psql command

2006-09-05 Thread Iuri Sampaio 
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


'>'-- Mensagem Original --
 '>'From: Bud Rogers <[EMAIL PROTECTED]>
 '>'To: debian-user@lists.debian.org
 '>'Subject: Re: psql command
 '>'Date: Mon, 4 Sep 2006 13:53:11 -0500
 '>'
 '>'
 '>'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]
 '>'



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED] 
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: psql command

2006-09-04 Thread Bud Rogers 
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]

psql command

2006-09-04 Thread Iuri Sampaio 








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/bin:/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?

 

iuri