Обсуждение: Standard Input Passwords?

pg_dump -h server -Of ./temp.dmp -u username << END
username
password
END

<-- I've been trying to use this command and have always been able to
successfully dump my database via scripts.  Now, it prompts me despite this
standard input value, or any other one.  It just waits for me to enter
something.

This worked until I upgraded to 7.3.3 from 7.1.3.  Any ideas why this would
happen and how to work around it to get automatic scriped dumps?

Thanks in advance.

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

"Mike Miller" <temp6453@hotmail.com> writes:
> pg_dump -h server -Of ./temp.dmp -u username << END
> username
> password
> END

> This worked until I upgraded to 7.3.3 from 7.1.3.  Any ideas why this would
> happen and how to work around it to get automatic scriped dumps?

This is a deliberate change for security purposes: it wants to read the
password from /dev/tty not stdin.

I'd recommend that you abandon this approach and start keeping your
passwords in ~/.pgpass, instead.  See
http://developer.postgresql.org/docs/postgres/libpq-pgpass.html

            regards, tom lane