From: Tom Lane <tgl@sss.pgh.pa.us>
To: José António Gomes <jose.antonio.luanda@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: PostgreSQL 17 Service Running but Not Listening on Network Port on Windows
Date: Wed, 18 Jun 2025 16:51:58 -0400
Message-ID: <1179484.1750279918@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMxdt8iFLbJGyAqu=MFPsd8efvRZtV9uzYVEnpgdNBRsgXcaUg@mail.gmail.com>
References: <CAMxdt8iFLbJGyAqu=MFPsd8efvRZtV9uzYVEnpgdNBRsgXcaUg@mail.gmail.com>
=?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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, jose.antonio.luanda@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: PostgreSQL 17 Service Running but Not Listening on Network Port on Windows
In-Reply-To: <1179484.1750279918@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox