Re: Postgres listens on random port - Mailing list pgsql-general

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.