public inbox for [email protected]  

help / color / mirror / Atom feed

From: Kal <[email protected]>
To: Saul Perdomo <[email protected]>
Cc: [email protected]
Subject: Re: Postgres listens on random port
Date: Tue, 5 Nov 2024 20:04:24 +0530
Message-ID: <CACO9DYJuXdaHL338ZftaQWM-ZR_DLq0Wpg-y3krzwOBai3eXsA@mail.gmail.com> (raw)
In-Reply-To: <CAN3jBgGPjkrxG0E2SKjTo45heBRPEpLxNHvW8SN+4OAcq8rRuA@mail.gmail.com>
References: <CACO9DYKtYpE4yeV1r4Gp4hFC7=n_-fG7+Bj35F5M+v0s=ZEDWw@mail.gmail.com>
	<CAN3jBgGPjkrxG0E2SKjTo45heBRPEpLxNHvW8SN+4OAcq8rRuA@mail.gmail.com>

Hi

The netstat command did not reveal any entries on the intended port (say
5460). The 5460 port was vacant, no processes were using it.
 I had to crawl through the postgres processes on task manager to find the
listening port.


Could this be due interference from other services? But the port 5460
remains unused.


Regards,
Kal

On Tue, 5 Nov 2024 at 7:57 PM, Saul Perdomo <[email protected]> wrote:

> " But the database actually listens on some random port like 20011"
>
> How exactly did you determine this?
>
> (If you used, say, netstat, can you share its output with us?)
>
> On Tue, Nov 5, 2024 at 8:46 AM Kal <[email protected]> wrote:
>
>> Hi
>>
>> I have a scenario in which postgres listens on a random port different
>> from the one which was specified in pg_ctl start command.
>>
>> This occurs in windows. When postgres is started on port 5460, the logs
>> denote that postgres is started on 5460. But the database actually listens
>> on some random port like 20011
>>
>> When the same postgres is started as a service,it listens on the intended
>> port.
>>
>> I have tried with both normal and admin users.
>>
>> Any suggestions on this behaviour will be helpful.
>>
>>
>> Regards
>> Kal
>>
>

view thread (2+ messages)

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Postgres listens on random port
  In-Reply-To: <CACO9DYJuXdaHL338ZftaQWM-ZR_DLq0Wpg-y3krzwOBai3eXsA@mail.gmail.com>

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

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