Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43535=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YSMjK-00007v-2Q
 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 09:33:38 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43535=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YSMjJ-0002yF-Hw
 for pgsql-admin@arkaria.postgresql.org; Mon, 02 Mar 2015 09:33:37 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <pg@mnietz.de>) id 1YSMjI-0002y8-EV
 for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 09:33:36 +0000
Received: from www.mnietz.de ([78.47.150.78] helo=mail.mnietz.de)
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <pg@mnietz.de>) id 1YSMjE-00026y-Sd
 for pgsql-admin@postgresql.org; Mon, 02 Mar 2015 09:33:34 +0000
Received: from [127.0.0.1] (ip-178-202-232-156.hsi09.unitymediagroup.de
 [178.202.232.156])
 by mail.mnietz.de (Postfix) with ESMTPSA id C3E2018064B
 for <pgsql-admin@postgresql.org>; Mon,  2 Mar 2015 10:33:30 +0100 (CET)
Message-ID: <54F42E6B.4080009@mnietz.de>
Date: Mon, 02 Mar 2015 10:33:31 +0100
From: Marco Nietz <pg@mnietz.de>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64;
 rv:31.0) Gecko/20100101 Thunderbird/31.5.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Passing password in psql command
References: 
 <CAJyuQsGLmNfmD3a=Y64-d6cVfpc6Ummc7i+oLic6weR8Nh7-1Q@mail.gmail.com>
In-Reply-To: 
 <CAJyuQsGLmNfmD3a=Y64-d6cVfpc6Ummc7i+oLic6weR8Nh7-1Q@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.0 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

The best way is propably to use a .pgpass file, please see: 
https://wiki.postgresql.org/wiki/Pgpass for details

Marco

Am 02.03.2015 um 10:27 schrieb Technical Doubts:
> Dear Team,
> We are unable to connect to PostgreSQL db using psql by passing 
> password parameter. If we don't give password, then on password promt 
> it's accepting the password we type. But our scheduler script is 
> having the psql line with password parameter. Helps highly 
> appreciated. Thanks in advance.
> -
> John 



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin