Обсуждение: Psql bug on Windows or pilot error? ;-)

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"

Under Cygwin I get this:
$ ./psql -U postgres test < /cygdrive/d/temp/testdb_051705
Password:
psql: FATAL:  password authentication failed for user "postgres"


Under the Windows cmd shell or Cygwin's bash, I don't get the
opportunity to actually type my password - apparently the input from
stdin causes it to blow right past the passwd and it probably takes the
first few bytes of the input as my passwd, which fails, of course.

Does reloading a db under Windows work like this or am I doing something
wrong?  FWIW, this is 8.0.3 I just downloaded for windows and installed.
I'm sure I'm running the right version of psql that came with it (I've
checked the path).

Thanks in advance!

Bret

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