MIME-Version: 1.0
References: <CACO9DYKtYpE4yeV1r4Gp4hFC7=n_-fG7+Bj35F5M+v0s=ZEDWw@mail.gmail.com>
In-Reply-To: <CACO9DYKtYpE4yeV1r4Gp4hFC7=n_-fG7+Bj35F5M+v0s=ZEDWw@mail.gmail.com>
From: Saul Perdomo <saul.perdomo@gmail.com>
Date: Tue, 5 Nov 2024 09:26:46 -0500
Message-ID: <CAN3jBgGPjkrxG0E2SKjTo45heBRPEpLxNHvW8SN+4OAcq8rRuA@mail.gmail.com>
Subject: Re: Postgres listens on random port
To: Kal <kalel.code11@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e8990706262b316c"
Archived-At: <https://www.postgresql.org/message-id/CAN3jBgGPjkrxG0E2SKjTo45heBRPEpLxNHvW8SN%2B4OAcq8rRuA%40mail.gmail.com>
Precedence: bulk

--000000000000e8990706262b316c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

" 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=E2=80=AFAM Kal <kalel.code11@gmail.com> 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 listen=
s
> 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
>

--000000000000e8990706262b316c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">&quot; But the database actually listens on some random po=
rt like 20011&quot;<div><br></div><div>How exactly did you determine this?<=
/div><div><br></div><div>(If you used, say, netstat, can you share its outp=
ut with us?)</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" cla=
ss=3D"gmail_attr">On Tue, Nov 5, 2024 at 8:46=E2=80=AFAM Kal &lt;<a href=3D=
"mailto:kalel.code11@gmail.com">kalel.code11@gmail.com</a>&gt; wrote:<br></=
div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex">Hi=C2=A0<div dir=3D"a=
uto"><br></div><div dir=3D"auto">I have a scenario in which postgres listen=
s on a random port different from the one which was specified in pg_ctl sta=
rt command.</div><div dir=3D"auto"><br></div><div dir=3D"auto">This occurs =
in windows. When postgres is started on port 5460, the logs denote that pos=
tgres is started on 5460. But the database actually listens on some random =
port like 20011</div><div dir=3D"auto"><br></div><div dir=3D"auto">When the=
 same postgres is started as a service,it listens on the intended port.</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto">I have tried with both norm=
al and admin users.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Any =
suggestions on this behaviour will be helpful.=C2=A0</div><div dir=3D"auto"=
><br></div><div dir=3D"auto"><br></div><div dir=3D"auto">Regards=C2=A0</div=
><div dir=3D"auto">Kal</div>
</blockquote></div>

--000000000000e8990706262b316c--