drush-ops/drush — pull request #695 by greg-1-anderson (2014-06-26 19:28:12+00:00)
Title: Support database passwords in db_spec for postgres databases

If 'password' is set in a pgsql db_spec, then write a pgpass file, and point to it with the PGPASSFILE environment variable.

This should work for things like sql-cli and site-install. More work necessary for sql-dump and sql-sync.