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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: postgresql definitive list of network resources used/needed?
Date: 2022-08-11 15:11:19
Message-ID: f50aca21-7b85-6a26-6baf-ca3655663f3d@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/11/22 10:04, Scott Ribe wrote:
>> On Aug 11, 2022, at 8:38 AM, richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Johannes Truschnigg 2022-08-11 15:22:36 Re: postgresql definitive list of network resources used/needed?
Previous Message Scott Ribe 2022-08-11 15:04:35 Re: postgresql definitive list of network resources used/needed?