Re: Windows psql changes after 8.1.1

Magnus Hagander <mha@sollentuna.net>

From: "Magnus Hagander" <mha@sollentuna.net>
To: "John DeSoi" <desoi@pgedit.com>, "PostgreSQL-development Hackers" <pgsql-hackers@postgresql.org>
Date: 2006-11-23T14:12:39Z
Lists: pgsql-hackers
> Hi,
> 
> My editor starts a shell session to communicate with psql. On 
> builds after 8.1.1 this is no longer working on Windows. It 
> seems that I'm no longer getting the password prompt (even if 
> using the -W).  
> Everything appears to be the same as before if I run 
> interactively from the command line. I tried to compare the 
> source, but I could not find anything that would explain the 
> difference (and no problems on the Mac).
> 
> Any suggestions on where to look?

Hmm, not sure why that changed after 8.1.1 - I see changes in 8.1.4
only. But - you're not supposed to send the password over stdin/stdout.
I would suggest you set the PGPASSWORD environment variable in the
custom environment. (it's secure on windows)

//Magnus