Re: alternate psql file locations

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Aidan Van Dyk <aidan(at)highrise(dot)ca>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: alternate psql file locations
Date: 2012-01-01 21:05:34
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 12/31/2011 04:26 PM, Aidan Van Dyk wrote:
> On Sat, Dec 31, 2011 at 3:17 PM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
>> Excerpts from Andrew Dunstan's message of sáb dic 31 12:52:02 -0300 2011:
>>> It's not a big thing, but I just found myself in a shared environment
>>> wanting to be able to set alternative locations for the psql startup
>>> file and history. I know there's the HISTFILE variable, but I can't
>>> easily set that automatically unless I can at least have my own .psqlrc.
>>> ISTM it should be a fairly simple thing to provide these, via
>>> environment variables. Is there general interest in such a thing?
>> I wanted such a thing mere two weeks ago ...
> Generally when I've wanted these things, I just make a new "$HOME" in
> my shared user home dir:
> export HOME=$HOME/aidan
> It's worked for things I've wanted, I haven't tried it for psql stuff....

Yeah, but it's a bit hacky. I might well not want $HOME reset. Here's a
small patch that does what I think would suit me and Alvaro.



Attachment Content-Type Size
psqlenv.patch text/x-patch 3.1 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Farina 2012-01-01 22:01:34 Re: backup_label during crash recovery: do we know how to solve it?
Previous Message Magnus Hagander 2012-01-01 14:13:37 Re: backup_label during crash recovery: do we know how to solve it?