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