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

2006-12-19 Thread Alvaro Herrera
Martijn van Oosterhout wrote:
 On Fri, Dec 01, 2006 at 10:37:07AM -0500, Tom Lane wrote:
  Martijn van Oosterhout kleptog@svana.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 Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


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

2006-12-19 Thread Peter Eisentraut
Alvaro Herrera wrote:
 So did we get anywhere with this?  I'd propose something like
 --non-interactive rather than --daemon-mode.  Was there a patch
 submitted?

With the enhanced connection string management, wouldn't it suffice to 
pass a (fake/empty) password to pg_dump on the command line?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings