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