Re: supplying password to psql on command line? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: supplying password to psql on command line?
Date
Msg-id 20021029145651.GC2042@dcc.uchile.cl
Whole thread Raw
In response to Re: supplying password to psql on command line?  (Christoph Dalitz <christoph.dalitz@hs-niederrhein.de>)
List pgsql-general
On Tue, Oct 29, 2002 at 08:52:12AM +0100, Christoph Dalitz wrote:
>
> > Date: Mon, 28 Oct 2002 10:56:32 -0800
> > From: Medi Montaseri <medi.montaseri@intransa.com>
> >
> > I think Font ends are moving away from this approach as others can see
> > your supplied
> > passwd by a simple ps(1) command.

> Unfortunately this does *not* work with psql because for some strange reason
> psql does not read the password from stdin.

You can always use PGPASSWORD.  And for those of you that find that
envvar insecure or cumbersome, there's a new ~/.pgpass where you can
store passwords in 7.3.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: ONE MORE PERFORMANCE ISSUE WITH POSTGRES
Next
From: "Johnson, Shaunn"
Date:
Subject: ps_dump -a