issue with reading hostname

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: issue with reading hostname
Date: 2024-04-22 20:13:58
Message-ID: CA+ONtZ4a9mJhBX2p4Ug8NSR+tHHuVvi-Vrcm3QyGMjkwNsuRPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-04-22 20:21:33 Re: CLUSTER vs. VACUUM FULL
Previous Message Tom Lane 2024-04-22 20:11:43 Re: altering a column to to make it generated