Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pw2BI-0007BA-Le for pgsql-hackers@arkaria.postgresql.org; Mon, 08 May 2023 14:49:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pw2BH-0000fN-M2 for pgsql-hackers@arkaria.postgresql.org; Mon, 08 May 2023 14:49:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pw2BH-0000fE-DB for pgsql-hackers@lists.postgresql.org; Mon, 08 May 2023 14:49:39 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pw2BE-001O2Z-VB for pgsql-hackers@lists.postgresql.org; Mon, 08 May 2023 14:49:38 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 348EnSFg416571; Mon, 8 May 2023 10:49:28 -0400 From: Tom Lane To: Alvaro Herrera cc: Yurii Rashkovskii , Stephen Frost , Peter Eisentraut , Robert Haas , Greg Stark , Andrew Dunstan , pgsql-hackers@lists.postgresql.org, Cary Huang Subject: Re: [PATCH] Allow Postgres to pick an unused port to listen In-reply-to: <20230508144301.tr2kvlihqddwp6ss@alvherre.pgsql> References: <20230508144301.tr2kvlihqddwp6ss@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Mon, 08 May 2023 16:43:01 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <416569.1683557368.1@sss.pgh.pa.us> Date: Mon, 08 May 2023 10:49:28 -0400 Message-ID: <416570.1683557368@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera writes: > This made me wonder if storing the unadorned port number is really the > best way. Suppose we did extend things so that we listen on different > ports on different interfaces; how would this scheme work at all? Yeah, the probability that that will happen someday is one of the things bothering me about this proposal. I'd rather change the file format to support that first (it can be dummy for now, with all lines showing the same port), and then document it second. regards, tom lane