Re: Postgres listens on random port

From: Kal <kalel(dot)code11(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres listens on random port
Date: 2024-11-05 14:22:23
Message-ID: CACO9DYKsL8iisNBCxk6jtg1ZNdDYisKzdfT-9HcBVgOBjfCouQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Regards
Kal

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Saul Perdomo 2024-11-05 14:26:46 Re: Postgres listens on random port
Previous Message Greg Sabino Mullane 2024-11-05 14:11:40 Re: Postgres listens on random port