Re: BUG #14037: Move history file

On Sun, Mar 20, 2016 at 8:55 AM, <vendforce(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 14037
> Logged by: vendforce
> Email address: vendforce(at)gmail(dot)com
> PostgreSQL version: 9.5.1
> Operating system: linux
> Description:
>
> I want to move the .psql_history file that resides in $home
>
> In mysql you can do
> export MSQL_HISTDFILE=/newfolder/mysq_history,
> and the history file is created and remains in the exported string
>
> Id tried that with PYSQL_HISTFILE & PSQL_HISTFILE and it doesnt work
>
> Is there a way to move the history file to a different folder
>

​This is not a bug and it is documented in psql's documentation chapter -
so not exactly non-intuitive.

http://www.postgresql.org/docs/9.2/static/app-psql.html

​The only thing that might be surprising is that you actually have to
change it inside of psql (either via CLI option or meta-command) as opposed
to setting a shell environment variable.

David J.