Re: small pg_dump RFE: new --no-prompt (password) option

On 1-Dec-06, at 8:13 AM, Martijn van Oosterhout wrote:

> On Fri, Dec 01, 2006 at 07:46:59AM -0500, Dave Cramer wrote:
>>>
>> I'm forwarding this on behalf of Marc Hebert
>
> I saw it the first time.
Sorry about the double posting


>
>>> When we implemented this scripting in Java we faced one major issue:
>>> pg_dump may prompt for a password in a unpredictable way  
>>> (depending on
>>> the user misconfiguration). Taking care of this is surprisingly
>>> complex.  The suggested --no-prompt would make scripting pg_dump
>>> infinitely easier.  In case a password is needed, this option would
>>> simply fail and return immediatly with an appropriate error message.
>>> Or even better, with a well-defined return status.
>
> Seems to me that you could just do this by setting stdin to be
> /dev/null?
I think a well defined error message makes sense.
>
> Have a nice day,
> -- 
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/ 
> kleptog/
>> From each according to his ability. To each according to his  
>> ability to litigate.