I noticed that when I am done using 'psql' as my superuser account, there's always a '.psql_history' file in my user's home directory. Now I've made all the precautions to make sure that nobody but me can access my home directory but I find it very disturbing that my commands and passwords for PostgreSQL are listed in plain text via this one text file. Is there a way to stop this? I don't know if this is done via Linux shell or PostgreSQL program itself that generates the file.
Anyone know if it's possible to omit the '.psql_history' file?