Re: [BUGS] psql: no chance to enter password in certain situations

> Christoph Becker <[email protected]> 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
> > Password:
> > 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.

Here are some more alternatives:
1. Setup PGPASSWORD in environment variables
2. use set to do a temporary version of above.  This is pretty flexible
if you don't want to use -f for some reason
3. temporarily edit pg_hba.conf to trust your terminal while restoring
4. set up the psql password file (haven't tried this on win32 yet)

Merlin

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [email protected])