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

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.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.