Database.yml, postgresql and pgpass.conf conflicts


I noticed that, on Windows at least, if I have a password set in the
database.yml file for a database that I also have in my pgpass.conf
file, the Rails adapter will die with a password authentication error.
I don’t seem to have this issue on Unix systems.

It’s simple enough to solve - just comment out the password info in the
database.yml file. I just wondered if there was a more generic
solution (other than “don’t do that”), or a way to improve the adapter
so that it Does The Right Thing.