Postgres Pro
Downloads
Home   >   mailing lists

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

From Kal
Subject Re: Postgres listens on random port
Date
Msg-id CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres listens on random port  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: Postgres listens on random port
Re: Postgres listens on random port
Re: Postgres listens on random port
List pgsql-general
Tree view


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.


Regards
Kal

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Postgres listens on random port
Next
From: Saul Perdomo
Date:
Subject: Re: Postgres listens on random port