issue with reading hostname - Mailing list pgsql-general

From Atul Kumar
Subject issue with reading hostname
Date
Msg-id CA+ONtZ4a9mJhBX2p4Ug8NSR+tHHuVvi-Vrcm3QyGMjkwNsuRPw@mail.gmail.com
Whole thread Raw
Responses Re: issue with reading hostname  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: issue with reading hostname  (Ron Johnson <ronljohnsonjr@gmail.com>)
Re: issue with reading hostname  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Hi,

I have postgresql  version 15 running on centos7.

I have below query that reads hostname from /tmp directory:

psql postgres -A -t -p 5432 -h /tmp/ -c 'SELECT pg_is_in_recovery();'


so below are my questions:

1. Is the psql client reading the socket file that resides in the /tmp directory to fetch the hostname ?

2. I saw the socket file in /tmp and it is empty. Then how is the psql client still reading the socket file successfully for hostname ?


this is my socket looks ( the size is 0 as the file is empty):

srwxrwxrwx.  1 postgres postgres      0 Apr 22 12:47 .s.PGSQL.5432


Please help me clarify these doubts.



Regards.






pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: altering a column to to make it generated
Next
From: Adrian Klaver
Date:
Subject: Re: CLUSTER vs. VACUUM FULL