Re: Psql bug on Windows or pilot error? ;-)

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