MIME-Version: 1.0
References: <CACO9DYKtYpE4yeV1r4Gp4hFC7=n_-fG7+Bj35F5M+v0s=ZEDWw@mail.gmail.com>
 <CAKAnmm+iDooPV=6WgJMeaXiUeCJ26NMU6ZrH00W2JNziQJv3JA@mail.gmail.com>
In-Reply-To: <CAKAnmm+iDooPV=6WgJMeaXiUeCJ26NMU6ZrH00W2JNziQJv3JA@mail.gmail.com>
From: Kal <kalel.code11@gmail.com>
Date: Tue, 5 Nov 2024 19:52:23 +0530
Message-ID: <CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ@mail.gmail.com>
Subject: Re: Postgres listens on random port
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000855e406262b22ae"
Archived-At: <https://www.postgresql.org/message-id/CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ%40mail.gmail.com>
Precedence: bulk

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

On Tue, 5 Nov 2024 at 7:42=E2=80=AFPM, Greg Sabino Mullane <htamfids@gmail.=
com>
wrote:

> Start by seeing where the port is actually being set by running this:
>
> select setting, source, sourcefile, sourceline from pg_settings where nam=
e
> =3D 'port';
> Cheers,
> Greg
>
> Hi Greg,

The query output states the source as command line. Event the port value
output from show port is same as given in pg_ctl command.

But the database is listening on some other random port.


Regards
Kal

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

<div><br></div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Tue, 5 Nov 2024 at 7:42=E2=80=AFPM, Greg Sabino Mullane =
&lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail.com</a>&gt; wrote:=
<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-le=
ft-color:rgb(204,204,204)"><div dir=3D"ltr">Start by seeing where the port =
is actually being set by running this:<div><br></div><div>select setting, s=
ource, sourcefile, sourceline from pg_settings where name =3D &#39;port&#39=
;;</div><div>Cheers,</div><div>Greg</div><div><br></div></div>
</blockquote></div></div><div dir=3D"auto">Hi Greg,</div><div dir=3D"auto">=
<br></div><div dir=3D"auto">The query output states the source as command l=
ine. Event the port value output from show port is same as given in pg_ctl =
command.</div><div dir=3D"auto"><br></div><div dir=3D"auto">But the databas=
e is listening on some other random port.</div><div dir=3D"auto"><br></div>=
<div dir=3D"auto"><br></div><div dir=3D"auto">Regards</div><div dir=3D"auto=
">Kal</div>

--0000000000000855e406262b22ae--