Skip site navigation (1) Skip section navigation (2)

Re: psql: default base and password reading

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adam Osuchowski <adwol(at)polsl(dot)gliwice(dot)pl>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: psql: default base and password reading
Date: 2001-10-13 18:14:40
Message-ID: Pine.LNX.4.30.0110122204290.648-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-patches
Tom Lane writes:

> > 2. Password is reading from terminal (/dev/tty) rather than from
> > stdin.
>
> Hmm, that might be a good idea.  Comments anyone?

I guarantee you that within 24 hours after such a patch were checked in
someone's going to complain that he has no /dev/tty.

Meanwhile, there are a couple of possible workarounds:

* PGPASSWORD environment variable.

* FIFOs

* (echo "Password"; pipe_input) | psql

A generalized option to read the password from any file might make sense,
though.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

Responses

pgsql-patches by date

Next:From: Peter EisentrautDate: 2001-10-13 19:23:10
Subject: Re: Showing index details with \d on psql
Previous:From: Bruce MomjianDate: 2001-10-13 17:14:32
Subject: Re: psql: default base and password reading

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group