Re: Adding Unix domain socket path and port topg_stat_get_wal_senders()

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Adding Unix domain socket path and port topg_stat_get_wal_senders()
Дата
Msg-id ce3a2fec-fc40-f7c6-8618-7e61a57f83e7@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COLLATE: Hash partition vs UPDATE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Adding Unix domain socket path and port to pg_stat_get_wal_senders()