pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Johannes Truschnigg <johannes@truschnigg.info>
To: richard coleman <rcoleman.ascentgl@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: postgresql definitive list of network resources used/needed?
Date: Thu, 11 Aug 2022 17:22:36 +0200
Message-ID: <YvUevMlj1+5wxKVI@vault.lan> (raw)
In-Reply-To: <CAGA3vBtLg=NLHQNjmVGAStWE2v5iwKw2nP+n=-6s_4USQuMEPA@mail.gmail.com>
References: <CAGA3vBstbWk88KvfJD0WzR89omKy9v+P_Z-S4p=_HC0g-xR58w@mail.gmail.com>
	<200DE464-2992-4D0C-96F1-6656E1CE932A@elevated-dev.com>
	<384610.1660168232@sss.pgh.pa.us>
	<CAGA3vBvvrbZNHRtfs+6DQtqJ3QRONaXhJAAooWmLm75j_F3U+A@mail.gmail.com>
	<CAKFQuwbjSOrUC3xQHxeTAcTys38s1yOCEA0Z9_N+xCkb0sMyjQ@mail.gmail.com>
	<CAGA3vBv9gqzhCao9q4sLRWcRxDVHYuM0YHH91SqQCz-5T6RWkA@mail.gmail.com>
	<484836.1660227202@sss.pgh.pa.us>
	<CAGA3vBtLg=NLHQNjmVGAStWE2v5iwKw2nP+n=-6s_4USQuMEPA@mail.gmail.com>

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

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (12+ messages)

Message-ID: <YvUevMlj1+5wxKVI@vault.lan>
Permalink:  ../YvUevMlj1+5wxKVI@vault.lan/
Also on:    postgresql.org/message-id/YvUevMlj1+5wxKVI@vault.lan

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: johannes@truschnigg.info, rcoleman.ascentgl@gmail.com
  Subject: Re: postgresql definitive list of network resources used/needed?
  In-Reply-To: <YvUevMlj1+5wxKVI@vault.lan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox