Re: postgresql definitive list of network resources used/needed?

Поиск
Список
Период
Сортировка
От Johannes Truschnigg
Тема Re: postgresql definitive list of network resources used/needed?
Дата
Msg-id YvUevMlj1+5wxKVI@vault.lan
обсуждение исходный текст
Ответ на Re: postgresql definitive list of network resources used/needed?  (richard coleman <rcoleman.ascentgl@gmail.com>)
Список pgsql-admin
On Thu, Aug 11, 2022 at 10:38:51AM -0400, richard coleman wrote:
> Tom,
>
> [...]
>
> It seems less likely with every exchange that a listing of network ports
> used/needed does exist.  That's a shame.
>
> I guess if I find myself in the situation where I really need that listing,
> I'll have to dust off my *extremely* rusty C skills and pour through the
> source code.

You are probably better off using the tools your platform/OS provides you with
to gather that information at runtime. Assuming GNU/Linux, there's ss(8) and
lsof(8) to superficially monitor TCP connections and activity.

If you are lucky enough to have bpftrace(8) available, you can cobble
something together on your own, or resort to the provided tcpaccept(8) script
to gather interesting data points, and draw your conclusions from that.

--
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )

www:   https://johannes.truschnigg.info/
phone: +436502133337
xmpp:  johannes@truschnigg.info

Вложения

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: postgresql definitive list of network resources used/needed?
Следующее
От: jian xu
Дата:
Сообщение: a question about Point-in-Time Recovery (PITR)