manage.py dbshell requires password for PostgreSQL databases
|Reported by:||gnosek||Owned by:||nobody|
|Component:||Core (Management commands)||Version:||1.4|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
SQLite and MySQL databases can be accessed using manage.py dbshell without entering any passwords. This isn't the case with PostgreSQL, which requires copying the password from settings.py and pasting it again after psql's prompt.
We can use ~/.pgpass files but they have to be set up in advance, which is still annoying.
To the best of my knowledge, passing the password via the environment is not a security risk.