Re: Storing pgpassword on Win32 Machines

Although previous posts explicitely stated that no non-ascii chars where 
involved, I'm quite sure that this is in fact the problem. I created a 
user with a non-ascii password, and immediately was able to reproduce 
the problem.

Passwords entered in pgAdmin are in Unicode, and are converted when sent 
to the backend. Unfortunately, at connect time some default conversion 
rules are applied, so pgAdmin can't be sure whether converted or 
non-converted passwords are needed; it will try both when connecting 
interactively.

When libpq evaluates pgpass.conf (or ~.pgpass on *ix), it will *not* try 
several conversions, instead it will use the string as-is.

I changed pgAdmin now to store the pgpass info in the format that it has 
found suitable from the last successful connect. Please check the latest 
snapshot (win32 available now, *ix tomorrow after nightly build), and 
give me feedback if it works for you. If it does not, I really need the 
pgpass.conf line to dig further.

Regards,
Andreas