"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
