Re: Postgres listens on random port

On 2024-11-05 15:22 +0100, Kal wrote:
> On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mullane <htamfids(at)gmail(dot)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