"Mike Miller" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
