Re: Postgres listens on random port

On 11/5/24 06:22, Kal wrote: On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mullane > 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'; Cheer

Re: Postgres listens on random port

Agreed - it sounds like OP found a *client *process and mistook it for a server process, which is why I wanted to know where exactly he saw this. On Tue, Nov 5, 2024 at 9:41 AM Ron Johnson wrote: > On Tue, Nov 5, 2024 at 9:22 AM Kal wrote: > >> >> On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mull

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 > 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 > >

Re: Postgres listens on random port

On Tue, Nov 5, 2024 at 9:22 AM Kal wrote: > > On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mullane > 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 >>

Re: Postgres listens on random port

Hi The netstat command did not reveal any entries on the intended port (say 5460). The 5460 port was vacant, no processes were using it. I had to crawl through the postgres processes on task manager to find the listening port. Could this be due interference from other services? But the port 546

Re: Postgres listens on random port

" But the database actually listens on some random port like 20011" How exactly did you determine this? (If you used, say, netstat, can you share its output with us?) On Tue, Nov 5, 2024 at 8:46 AM Kal wrote: > Hi > > I have a scenario in which postgres listens on a random port different > fro

Re: Postgres listens on random port

On Tue, 5 Nov 2024 at 7:42 PM, Greg Sabino Mullane 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

Re: Postgres listens on random port

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

Postgres listens on random port

Hi I have a scenario in which postgres listens on a random port different from the one which was specified in pg_ctl start command. This occurs in windows. When postgres is started on port 5460, the logs denote that postgres is started on 5460. But the database actually listens on some random por