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

Martijn van Oosterhout wrote:
> On Fri, Dec 01, 2006 at 10:37:07AM -0500, Tom Lane wrote:
> > Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> > > Seems to me that you could just do this by setting stdin to be
> > > /dev/null?
> >
> > No, because the simple_prompt code makes a point of reading from
> > /dev/tty.
>
> Sure, but that would fail for any process which has detached from the
> terminal. The backup is stdin, which you can also setup.
>
> Admittedly, the OP may not be in a position to setup the environment in
> such a way as to make it work, which means that such an option may be
> worthwhile...
>
> If it's going to be an option, I'd suggest something like --daemon-mode
> since it's entirely possible other issues tmay come up later that might
> need this kind of attention.

So did we get anywhere with this? I'd propose something like
--non-interactive rather than --daemon-mode. Was there a patch
submitted?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support