Re: HOST variable in psql - Mailing list pgsql-general

From Tom Lane
Subject Re: HOST variable in psql
Date
Msg-id 9170.1587993191@sss.pgh.pa.us
Whole thread Raw
In response to Re: HOST variable in psql  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: HOST variable in psql
List pgsql-general
=?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com> writes:
>> On 27. Apr, 2020, at 14:20, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> AFAICS, psql is behaving as documented.  Why are you trying to override
>> HOST like that, instead of just using some other variable?

> I could but

> a) HOST is HOST and should not point to a socket directory. A socket directory is not a HOST. This makes no sense,
especiallysince I see no use for using a socket directory in any psql script. There are tons of use cases for the
hostname,though. 

[ shrug... ]  When connecting via a Unix socket, psql does not have a
relevant "hostname" to report, so it reports what it's got.  You are
ascribing a meaning to HOST that it does not have, never has had, and
never can have in this case.

> c) the docs are IMHO not 100% clear on this. I think the psqlrc should be executed on EVERY new connect, hence
including\c, and this is how I interpret the docs too. But it doesn't... 

There has been some talk of providing a way to execute stuff on reconnect,
if memory serves, but nothing's been done about it.

            regards, tom lane



pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;'
Next
From: Matthias Apitz
Date:
Subject: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPAREsid_sisisinst FROM :select_anw;'