The .psql_history file is naturally used by different DB connections (distinguished by a different combination of host + port + database + user).
At least in my multi-database working environment, this leads sometimes to frustration because there are commands that cannot or should not be used by different connections.
To solve this, psql could keep a separate command history file for each connection.
I will be happy to make this my first contribution to PostgreSQL's code.
