From: a.mitrokhin@postgrespro.ru
To: Kirill Reshke <reshkekirill@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Starting a PostgreSQL server on a dynamic port (parameter port=0)
Date: Thu, 10 Jul 2025 15:29:53 +0700
Message-ID: <a03d0696a0b98a1e91947ffdefa9d6fc@postgrespro.ru> (raw)
In-Reply-To: <CALdSSPgNJWenx+wGt2pL4oFcuZw21=C3B8AB27b_kayuWZB6yw@mail.gmail.com>
References: <824bbf6be5fa0edf6a7d4c8371ce67ce@postgrespro.ru>
<CALdSSPgNJWenx+wGt2pL4oFcuZw21=C3B8AB27b_kayuWZB6yw@mail.gmail.com>
Kirill Reshke писал(а) 2025-07-10 14:46:
> On Thu, 10 Jul 2025 at 12:15, <a.mitrokhin@postgrespro.ru> wrote:
>>
>> Hello.
>>
>>
>> Postgres does not allow starting the server with port=0, which
>> prevents
>> it from obtaining an arbitrary free port from the kernel.
>>
>>
>> ~$ LANG=C pg_ctl -D data -o "-c port=0" start
>> 2025-07-10 05:27:02.785 GMT [702503] FATAL: 0 is outside the valid
>> range for parameter "port" (1 .. 65535)
>>
>>
>> This makes it unreliable to start the server in my tests without the
>> risk of port conflicts with already running programs, unless resorting
>> to an unreliable and race-condition-prone procedure of reserving ports
>> in advance.
>>
>>
>> Could you please fix this?
>
>
> Regression tests somehow solve this problem without any patch, so why
> this should be fixed?
This has nothing to do with Postgres regression tests. The issue is
the practical benefit of using a dynamic port, which we're depriving
ourselves of.
If you're not interested in this behavior, you'll never use it. But
there are cases where it can be very convenient. Why artificially
restrict functionality that is simple, doesn't conflict with anything,
and has no negative side effects?
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: a.mitrokhin@postgrespro.ru, reshkekirill@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Starting a PostgreSQL server on a dynamic port (parameter port=0)
In-Reply-To: <a03d0696a0b98a1e91947ffdefa9d6fc@postgrespro.ru>
* 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