Horton
Menu

Re: PostgreSQL 17 Service Running but Not Listening on Network Port on Windows

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: José António Gomes <jose.antonio.luanda@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2025-06-18T20:51:58Z
Lists: pgsql-bugs 
=?UTF-8?B?Sm9zw6kgQW50w7NuaW8gR29tZXM=?= <jose.antonio.luanda@gmail.com> writes:
> *Subject: PostgreSQL 17 Service Running but Not Listening on Network Port
> on Windows*

Did you examine the postmaster log?  The first few lines should show
what ports it bound to.  For example, on a Linux box I see

2025-06-14 12:48:07.536 EDT [12649] LOG:  starting PostgreSQL 17.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-26), 64-bit
2025-06-14 12:48:07.536 EDT [12649] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-06-14 12:48:07.536 EDT [12649] LOG:  listening on IPv6 address "::", port 5432
2025-06-14 12:48:07.536 EDT [12649] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2025-06-14 12:48:07.543 EDT [12653] LOG:  database system was shut down at 2025-06-14 12:21:00 EDT
2025-06-14 12:48:07.554 EDT [12649] LOG:  database system is ready to accept connections

This won't immediately reveal the problem, I imagine, but it would
help decide where to look.

			regards, tom lane