Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Euler Taveira <euler(at)timbira(dot)com(dot)br>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()
Date: 2019-04-15 21:01:30
Message-ID: ce3a2fec-fc40-f7c6-8618-7e61a57f83e7@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2019-04-12 17:57, Tom Lane wrote:
>> For a socket connection, directory is important and that
>> information I can get from unix_socket_directories parameter (I've
>> never seen a setup with multiple socket directories).
> Those are actually pretty common, for example if you use Red Hat's
> packaging you will have both /var/run/postgresql and /tmp as socket
> directories (since they consider use of /tmp deprecated, but getting
> rid of all clients' use of it turns out to be really hard). However,
> it's definitely fair to question whether anyone *cares* which of
> the server's socket directories a given connection used. Aren't
> they going to be pretty much all equivalent?

So what is being asked here is really information about which end point
on the server is being connected to. That is also information for the
TCP/IP case that we don't currently provide. It's probably of marginal
use, as you also say.

I don't get what this has to do with walsenders specifically. Do they
have each walsender connect to a different socket?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-04-15 21:15:57 Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()
Previous Message Tom Lane 2019-04-15 20:47:46 Re: COLLATE: Hash partition vs UPDATE