Date: Thu, 11 Aug 2022 17:22:36 +0200
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?
Message-ID: <YvUevMlj1+5wxKVI@vault.lan>
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>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="rkJN5J38e1GBrD05"
Content-Disposition: inline
In-Reply-To: 
 <CAGA3vBtLg=NLHQNjmVGAStWE2v5iwKw2nP+n=-6s_4USQuMEPA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YvUevMlj1%2B5wxKVI%40vault.lan>
Precedence: bulk


--rkJN5J38e1GBrD05
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Aug 11, 2022 at 10:38:51AM -0400, richard coleman wrote:
> Tom,
>=20
> [...]
>=20
> It seems less likely with every exchange that a listing of network ports
> used/needed does exist.  That's a shame.
>=20
> I guess if I find myself in the situation where I really need that listin=
g,
> 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 w=
ith
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) scri=
pt
to gather interesting data points, and draw your conclusions from that.

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

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

--rkJN5J38e1GBrD05
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAmL1HrgACgkQ95W3jMsY
fLWhDw//Y6Pl22+gZQ4hWaTkkkL6RMenoNUsY6AbPit7NInEMueWxR/52VQtbuhN
4mIn0md+62cVrI7jD/Z8o0axD5KsAqV3Nf9veHFGNVEAcf8LJwByGKdLPuqb0c8Y
l/DrxCwJZ0KfGol15uvhK17iyA1yvLA0jVgdi3edX8EPP1b/WCW0uZU7CtMlx8iS
gKbKWQRf64Bzl4E9K/4DIlYaz11gv1uNyhMSla5NY8KZ4AxRApf/jilyBT7reM9O
uFZrcWqV67nc781rjRkRfaP9qMN/WZ22XjYJOy4w/G60+fKvKOxWmyT8+ajjbSEh
Afh3lzXsW0SCTNVCIefs+dSK61Vm4T0Snryyt0aPvbnNnN4txQk1xR8fssp1KGHI
2uPDWFRDF3LHXGQ1Ep7J9o6z8OW/da/QYn5H0dTRKVzI2v5ap7d+gh0h+YnVumvl
LxSvLzaP3l+dmvLx74nR3MzNrnRmSMCKVddwzxtTVNjIOFl0Yb+HgaA6gTHmoDJ6
t/wM+PjwwRM42kc0S2un1L7CiyfI81np86GhUXKX81tzKmQL/QAQ7IY/kP7bH0YE
/9dIbZe04swp18yHvOB+dP0OXQIKy87Ndgg4LBwyFVexQZELeskZawR3r9fJhB0t
5uQBWWBykUkVJtzxIFLA3ADu415zhnBevA1DNC1WrQ4Kt82Wy98=
=zPJ6
-----END PGP SIGNATURE-----

--rkJN5J38e1GBrD05--