On May 18, 2005, at 8:58 AM, Schuhmacher, Bret wrote:
> I'm trying to restore a db I dumped on Linux to a windows box for local
> development. When I run this on Linux
> ./psql test < dumpfile, I get prompted for a password.
>
> On windows, the same command is shown below:
> C:\Program Files\PostgreSQL\8.0\bin>psql -U postgres test <
> d:\temp\testdb_05170
> 5
> Password:
> psql: FATAL: password authentication failed for user "postgres"
There seems to be a problem on Windows using '<'. Try this instead:
C:\Program Files\PostgreSQL\8.0\bin>psql -U postgres -f
d:\temp\testdb_05170 test
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL