Re: BUG #14037: Move history file

On Mon, Mar 21, 2016 at 8:50 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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.
>
>
​edit: apparently didn't scroll down far enough - bricklen is correct about
their ALSO being a shell environment variable.

Dav
​id J.