Message-ID: <f50aca21-7b85-6a26-6baf-ca3655663f3d@gmail.com>
Date: Thu, 11 Aug 2022 10:11:19 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.9.1
Subject: Re: postgresql definitive list of network resources used/needed?
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
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>
 <62A6BB7E-2BD7-4701-B59A-88A7D8F2AE82@elevated-dev.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: <62A6BB7E-2BD7-4701-B59A-88A7D8F2AE82@elevated-dev.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/f50aca21-7b85-6a26-6baf-ca3655663f3d%40gmail.com>
Precedence: bulk

On 8/11/22 10:04, Scott Ribe wrote:
>> On Aug 11, 2022, at 8:38 AM, richard coleman <rcoleman.ascentgl@gmail.com> wrote:
>>
>> If you read the entire line you quoted, I was trying to confirm that intrinsic features and utilities, including pg_dump, don't use any **other** network ports
> Right. "Standard" utilities don't. pg_dump, pg_basebackup, fdw, etc all connect to PG as clients--which means they connect to 5432, from whatever random port the OS assigns to that connection.

Exactly.  Postgresql uses 5432.  Other RDBMSs (for example SQL Server) use 
more than just the client port number because they bundle other features 
into their products and decide to send features like mirroring over 
different port numbers.


-- 
Angular momentum makes the world go 'round.