PostgreSQL Command History Problem

We had a problem in on of our DB Servers running PostgreSQL that when a user logs in as the postgres user, the history of the commands that he enters stays only as long as the user is logged in. That is when the postgres user logs out, the history of commands that were entered previously were cleared out.

The following method solved this problem .

Create a .bash_history file in the home directory of the Postgres User.


This helped in retaining the History of commands used by the User.