Christoph Becker <cgbecker(at)gmx(dot)de> writes:
> OS ist Windows XP Prof, PgSQL version is rc5 via windowsinstaller
> When trying to restore a db, psql does not ask for the password but
> responds imediately with an erromessage as in the following example:
> F:\doka\bak>psql -U postgres template1 < pg_dump_all_2005-01-11.txt
> psql: FATAL: password authentication failed for user "postgres"
I'm not sure that it's possible to fix that. On Unix we read the
password from /dev/tty not stdin, but on Windows that trick (probably)
does not work, and we have to fall back to reading from stdin ...
which you've stuffed with the input file. Better to use -f to source
the input file.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Magnus Hagander||Date: 2005-01-13 09:41:05|
|Subject: Re: rc4 and rc3, some deleted, but still needed text in the|
|Previous:||From: Steve Nicolai||Date: 2005-01-13 00:29:45|
|Subject: BUG #1394: LIKE doesn't seem to use an index|
pgsql-hackers-win32 by date
|Next:||From: M.N. Swaminathan||Date: 2005-01-13 04:46:13|
|Subject: Re: Bugs]|
|Previous:||From: John R Pierce||Date: 2005-01-12 23:32:06|
|Subject: Re: psql: no chance to enter password in certain situations|