Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens

> At 01:08 AM 11/28/01 -0500, Tom Lane wrote:
> >Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> ... But because we are Internet-enabled,
> >> and because our insecurity is only local, it seems OK to people.
> >
> >It's not that it's "okay", it's that we haven't got any good
> >alternatives. Password auth sucks from a convenience point of view
> >(or even from a possibility point of view, for scripts; don't forget
> >the changes that you yourself recently applied to guarantee that a
> >script *cannot* supply a password to psql). Ident auth doesn't work,
> >
>
> Ack. We can't send in passwords to psql anymore? :(
>
> Is there a safe way to send username and password to psql?

The standard way I know of is to use 'expect' and wrap your psql call
around that.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026