From iuri.sampaio@gmail.com Thu Sep 7 06:01:32 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 13AC89F94F3 for ; Thu, 7 Sep 2006 03:01:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 23492-04-2 for ; Thu, 7 Sep 2006 03:01:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 0C5B29FB25B for ; Thu, 7 Sep 2006 02:56:55 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so117514wxc for ; Wed, 06 Sep 2006 22:56:55 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:subject:date:message-id:mime-version:content-type:x-mailer:x-mimeole:thread-index; b=VUty3/X4tXmYLpP6TEpxEzw3N+EJ8QKA/GAdzbO4xeomz0yvwdeIYLZmZU3XdKj9nhHQd96tSGdu1CSDQcu+if3+lQ/A9s95bMnWaSl5bZDCHqQTBpUFzBfFd0LuEn+Kj6c5IKHTcRxIIwh9pN3LQb87S/BGznFTD/a55L6imt8= Received: by 10.70.21.10 with SMTP id 10mr530518wxu; Wed, 06 Sep 2006 22:56:54 -0700 (PDT) Received: from LAPTOP ( [201.12.191.104]) by mx.gmail.com with ESMTP id 8sm316451wra.2006.09.06.22.56.53; Wed, 06 Sep 2006 22:56:54 -0700 (PDT) Reply-To: From: "Iuri Sampaio" To: Subject: psql command Date: Thu, 7 Sep 2006 02:56:46 -0300 Message-ID: <000301c6d242$68aadb20$6401a8c0@LAPTOP> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C6D229.435DA320" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Thread-Index: AcbSQmb9SbK7OzY8RiWyNwtuR0batQ== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/118 X-Sequence-Number: 23032 This is a multi-part message in MIME format. ------=_NextPart_000_0004_01C6D229.435DA320 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit The postgres commands work fine to postgres user but it doesn't work to a random 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? iuri ------=_NextPart_000_0004_01C6D229.435DA320 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

The postgres commands work fine to postgres user but = it doesn’t work to a random 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=3D:/usr/local/pgsql/lib:/usr/local/pgs= ql/lib

PATH=3D/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/= games:/usr/local/pgsql/bin:/usr/local/pgsql/bin<= /p>

 

 

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?

 

iuri

 

------=_NextPart_000_0004_01C6D229.435DA320-- From iuri.sampaio@gmail.com Thu Sep 7 06:02:05 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A2B239FA222 for ; Thu, 7 Sep 2006 03:02:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 50572-03-5 for ; Thu, 7 Sep 2006 06:01:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.226]) by postgresql.org (Postfix) with ESMTP id 36A8E9FA474 for ; Thu, 7 Sep 2006 03:00:52 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id t13so118477wxc for ; Wed, 06 Sep 2006 23:00:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:subject:date:message-id:mime-version:content-type:x-mailer:x-mimeole:in-reply-to:thread-index; b=PCF9hZiWNNbRLasVTec+dZsh8N5mc1oW8n92g7tRxpeuD+oXHjAt2tRRAJfXujkreY/RuFV7lsBgL8hnR0gf/F2pljWVn3hw+Qey0WIuKS5EqPxPiuv/CRVApa6ASiTCvshTI//3cAfiZpJXMrhTuE07J2qP5m2M88SugJA/Dnk= Received: by 10.70.13.1 with SMTP id 1mr594793wxm; Wed, 06 Sep 2006 23:00:51 -0700 (PDT) Received: from LAPTOP ( [201.12.191.104]) by mx.gmail.com with ESMTP id 34sm319917wra.2006.09.06.23.00.49; Wed, 06 Sep 2006 23:00:50 -0700 (PDT) Reply-To: From: "Iuri Sampaio" To: Subject: Re: psql command Date: Thu, 7 Sep 2006 03:00:42 -0300 Message-ID: <000801c6d242$f5238ca0$6401a8c0@LAPTOP> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0009_01C6D229.CFD654A0" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 In-Reply-To: Thread-Index: AcbSQmb9SbK7OzY8RiWyNwtuR0batQAAEseg X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.479 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_MESSAGE, RCVD_IN_BL_SPAMCOP_NET, RCVD_IN_NJABL_PROXY, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200609/119 X-Sequence-Number: 23033 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C6D229.CFD654A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I forgot to contextualize, 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 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 _____ From: Iuri Sampaio [mailto:iuri.sampaio@gmail.com] Sent: Thursday, September 07, 2006 2:57 AM To: 'pgsql-admin@postgresql.org' Subject: psql command The postgres commands work fine to postgres user but it doesn't work to a random 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? iuri ------=_NextPart_000_0009_01C6D229.CFD654A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I forgot to = contextualize,

 

env | grep PATH = :

 

oacsbr@desktop:~$ = env | grep PATH

PATH=3D/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

 

 

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

 

 


From: Iuri = Sampaio [mailto:iuri.sampaio@gmail.com]
Sent: Thursday, September = 07, 2006 2:57 AM
To: = 'pgsql-admin@postgresql.org'
Subject: psql = command

 

The postgres commands work fine to postgres user but = it doesn’t work to a random 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=3D:/usr/local/pgsql/lib:/usr/local/pgs= ql/lib

PATH=3D/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/= games:/usr/local/pgsql/bin:/usr/local/pgsql/bin<= /p>

 

 

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?

 

iuri

 

------=_NextPart_000_0009_01C6D229.CFD654A0-- From mlists@rp-online.de Thu Sep 14 14:24:16 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B5AEF9F9F2F for ; Thu, 14 Sep 2006 11:24:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 43270-08 for ; Thu, 14 Sep 2006 11:24:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by postgresql.org (Postfix) with ESMTP id 2F6D29FA2E6 for ; Thu, 14 Sep 2006 11:24:07 -0300 (ADT) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id 221872EB88; Thu, 14 Sep 2006 16:24:05 +0200 (CEST) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online GmbH To: iuri.sampaio@computer.org, pgsql-admin@postgresql.org Subject: Re: psql command Date: Thu, 14 Sep 2006 16:24:28 +0200 User-Agent: KMail/1.9.4 References: <000801c6d242$f5238ca0$6401a8c0@LAPTOP> In-Reply-To: <000801c6d242$f5238ca0$6401a8c0@LAPTOP> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200609141624.28834.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.10/RELEASE, bases: 14092006 #210263, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.112 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/134 X-Sequence-Number: 23048 Hi, On Thursday 07 September 2006 08:00, Iuri Sampaio wrote: | 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/" that's because it's presumably installed under /usr/local/pgsql/bin -- look at the PATH variable for user postgres or check with "which psql" as user postgres. | oacsbr@desktop:~$ ls -l /usr/bin/psql | | ls: /usr/bin/psql: No such file or directory [...] | The postgres commands work fine to postgres user but it doesn't work to a | random user account | 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 | you want to repeat this step for other users required to run the "psql" command. Ciao, Thomas -- Thomas Pundt ---- http://rp-online.de/ ---- From htomeh@firstam.com Thu Sep 14 21:51:46 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 399379FA195 for ; Thu, 14 Sep 2006 18:51:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 73876-09 for ; Thu, 14 Sep 2006 18:51:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound-smtp.firstam.com (outbound-smtp6.firstam.com [69.87.54.11]) by postgresql.org (Postfix) with ESMTP id E4F679FA15C for ; Thu, 14 Sep 2006 18:51:34 -0300 (ADT) Received: from 10.48.129.31 by outbound-smtp.firstam.com with ESMTP ( Hello SMTP Relay); Thu, 14 Sep 2006 14:51:23 -0700 X-Server-Uuid: E605F9A5-E209-463E-810B-E76BE0E96D33 Received: from unknown (HELO pisgsna01smmx01.ana.firstamdata.com) ( [172.17.88.35]) by FAEMSNA01SMXS02.FIRSTAM.COM with ESMTP; 14 Sep 2006 14:51:25 -0700 Received: from pisgsna01sxch21.ana.firstamdata.com (Not Verified[172.17.88.71]) by pisgsna01smmx01.ana.firstamdata.com with MailMarshal (v6,1,6,1172) id ; Thu, 14 Sep 2006 14:51:24 -0700 Received: from pisgsna01sxch01.ana.firstamdata.com ([172.17.88.70]) by pisgsna01sxch21.ana.firstamdata.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 14 Sep 2006 14:51:23 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Subject: Re: psql command Date: Thu, 14 Sep 2006 14:51:23 -0700 Message-ID: In-Reply-To: <000301c6d242$68aadb20$6401a8c0@LAPTOP> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] psql command Thread-Index: AcbSQmb9SbK7OzY8RiWyNwtuR0batQGAZYPg From: "Tomeh, Husam" To: iuri.sampaio@computer.org, pgsql-admin@postgresql.org X-OriginalArrivalTime: 14 Sep 2006 21:51:23.0583 (UTC) FILETIME=[EBBB34F0:01C6D847] X-TMWD-Spam-Summary: SEV=1.1; DFV=A2006091408; IFV=2.0.6,4.0-7; RPD=4.00.0004; RPDID=303030312E30413031303230322E34353039434431452E303033313A5343464D413534333432342D462D2F4E4553574B563534472F71554B6D71577A564237673D3D; ENG=IBF; TS=20060914215124; CAT=NONE; CON=NONE; X-WSS-ID: 6917115148K70351-01-01 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6D847.EB90BA46" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200609/138 X-Sequence-Number: 23052 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6D847.EB90BA46 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable I can see your PATH variable has the path to postgres bin dir, but still looks like a environment variables issue. Have you double-check whether your PATH is exported. Run these at the Unix command line to make sure: =20 echo $PATH =20 which psql=20 =20 =20 The other thing that I'm not sure about is one of your output lines: =20 =20 -su: createdb: command not found =20 I was expecting to see "-bash" instead of "-su" as the shell name.=20 =20 -- =20 Husam =20 =20 ________________________________ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Iuri Sampaio Sent: Wednesday, September 06, 2006 10:57 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] psql command The postgres commands work fine to postgres user but it doesn't work to a random user account =20 I already created the user on postgres desktop:~# su - postgres postgres@desktop:~$ createuser -a -d oacsbr =20 and set on .bashrc=20 LD_LIBRARY_PATH=3D:/usr/local/pgsql/lib:/usr/local/pgsql/lib PATH=3D/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:/usr/local/pg= s ql/bin:/usr/local/pgsql/bin =20 =20 But somehow I can't run any commands such as=20 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 =20 =20 Does anyone knows what I've missed? =20 iuri =20 ********************************************************************** This message contains confidential information intended only for the use = of the addressee(s) named above and may contain information that is legal= ly privileged. If you are not the addressee, or the person responsible f= or delivering it to the addressee, you are hereby notified that reading, = disseminating, distributing or copying this message is strictly prohibite= d. If you have received this message by mistake, please immediately noti= fy us by replying to the message and delete the original message immediat= ely thereafter. Thank you. =0D =20 FADLD Tag ********************************************************************** ------_=_NextPart_001_01C6D847.EB90BA46 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
I can see=20 your PATH variable has the path to postgres bin dir, but still looks= =20like a=20 environment variables issue.
Have you=20 double-check whether your PATH is exported. Run these at the Unix command= =20line=20 to make sure:
 
echo=20 $PATH
 
which psql=20
 
 
The other=20 thing that I'm not sure about is one of your output lines:<= /DIV>
 
    &nb= sp;           &nbs= p;        =20 -su: createdb: command not found
 
I was=20 expecting to see  "-bash"  instead of =20 "-su"   as the shell name.
 
--
 =20 Husam
 
 

From: pgsql-admin-owner@postgres= ql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Iuri=20 Sampaio
Sent: Wednesday, September 06, 2006 10:57 PM
To:<= /B>=20 pgsql-admin@postgresql.org
Subject: [ADMIN] psql=20 command

The postgres commands work = fine to=20 postgres user but it doesn’t work to a random user=20 account

 

I already created the user = on=20 postgres

desktop:~# su -=20 postgres

postgres@desktop:~$ createu= ser -a -d=20 oacsbr

 

and set on .bashrc=20

LD_LIBRARY_PATH=3D:/usr/loc= al/pgsql/lib:/usr/local/pgsql/lib

PATH=3D/usr/local/bin:/usr/= bin:/bin:/usr/bin/X11:/usr/games:/usr/local/pgsql/bin:/usr/local/pgsql/bi= n

 

 

But somehow I can’t r= un any commands=20 such as

oacsbr@desktop:~$ createdb = -E UNICODE=20 mytestdb

-su: createdb: command not = found

oacsbr@desktop:~$ psql=20 -l

-su: psql: command not=20 found

oacsbr@desktop:~$ psql -l=20 mytestdb.dmp mytestdb

-su: psql: command not=20 found

 

 

Does anyone knows what I= 217;ve=20 missed?

 

iuri

 

**********************************************************************=
This=20 message contains confidential information intended only for the use of th= e=20 addressee(s) named above and may contain information that is legally=20 privileged.  If you are not the addressee, or the person responsible= =20for=20 delivering it to the addressee, you are hereby notified that reading,=20 disseminating, distributing or copying this message is strictly=20 prohibited.  If you have received this message by mistake, please=20 immediately notify us by replying to the message and delete the original = message=20 immediately thereafter.

Thank you.

          &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =              = FADLD=20 Tag
***********************************************************= ***********

------_=_NextPart_001_01C6D847.EB90BA46--