Date: Tue, 5 Nov 2024 15:43:58 +0100
From: Erik Wienhold <ewie@ewie.name>
To: Kal <kalel.code11@gmail.com>
Cc: Greg Sabino Mullane <htamfids@gmail.com>, pgsql-general@postgresql.org
Subject: Re: Postgres listens on random port
Message-ID: <3ce47d5d-2b4d-44d6-afc1-a10ddf46d4e1@ewie.name>
References: <CACO9DYKtYpE4yeV1r4Gp4hFC7=n_-fG7+Bj35F5M+v0s=ZEDWw@mail.gmail.com>
 <CAKAnmm+iDooPV=6WgJMeaXiUeCJ26NMU6ZrH00W2JNziQJv3JA@mail.gmail.com>
 <CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/3ce47d5d-2b4d-44d6-afc1-a10ddf46d4e1%40ewie.name>
Precedence: bulk

On 2024-11-05 15:22 +0100, Kal wrote:
> On Tue, 5 Nov 2024 at 7:42 PM, 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 name
> > = '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.

Please provide more details:

1) The complete pg_ctl command that you've executed.

2) Which Postgres version?

3) Which OS?

-- 
Erik