[ADMIN] Restoring pg_dump's made using COPY commands

2004-02-16 Thread Mike Miller
Hi, I'm trying to restore two dumps, one from 7.1.3 and the other from a 6.5.3 series PgSQL server. These dumps were both made using standard 'pg_dump > output' commands (specifying the host where needed on one of them). When I run the database restore by doing execute-file in psql, piping th

[ADMIN] Standard Input Passwords?

2003-07-31 Thread Mike Miller
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 somet