Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uPwrx-001LSC-Og for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Jun 2025 05:22:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uPwrt-0019Wp-TD for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Jun 2025 05:22:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uPwrt-0019UY-1O for pgsql-hackers@lists.postgresql.org; Fri, 13 Jun 2025 05:22:22 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uPwrq-001lZg-2Q for pgsql-hackers@postgresql.org; Fri, 13 Jun 2025 05:22:21 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfhigh.phl.internal (Postfix) with ESMTP id 467CA11400E1; Fri, 13 Jun 2025 01:22:16 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Fri, 13 Jun 2025 01:22:16 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm3; t=1749792136; x=1749878536; bh=GCbHhE0WFBSaLA7H7K7K5YKXkuOkN9F4 uXryt63Tp/A=; b=bIAVrngfOAJsQpwwNx62o8DySlTfa4k5bDopQzUGkyyFznpL v5VE5FjzRiIiSx1LXx1D51zxLyzH4st7BcPxbKpiELMcoFCYn1pvydFaaO/fJ6pO bS+XcQzXdTf38EVqWvgSJZXgFNwm2onY/lc6Eqm29FN+1ofbPGavw+9Jw9mwlx30 l+5c8rBbub7XEe1Au/10bEIyuQr6B+JpyOvQuv2MDqjPibmo6uALslqL0pcyLmeS GT1oTPhlOIjuwpdqtpgxoTBTz4yZhb986gAdSczx/0oK7VT7RuebjObYDM7xdCxr DuzLGpCf82DjY/B1xneqGe/wjVlaOt+UZUnhcA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1749792136; x= 1749878536; bh=GCbHhE0WFBSaLA7H7K7K5YKXkuOkN9F4uXryt63Tp/A=; b=M +tLxUcDVhVs1bW6QY3OF/ExmIKifydjEosjTxImoYgjcVYVwkiU1I+9YeQZHcSzH 6cEFxPA+wNFWKN30uNnQlmglqUeqVIP+BSAHtrK/QEbf2kKg6/KZChntpUkAzxST vgGXVEFbpJ6ui06L7XeNt2CLP2A10dpBGN3EzIUz96Y0UUnOWz+P4ZF7I+SOiA0r M1v/dvdVJ3K9oV9B4V05wI5lCF1DzydJtytVc/d1r7qyu6F0wWzKQqUScOmiwUnj I/jHz2Ok/bWQD7HH4+2P5jp22yW4kYn0m348c9NrLx60pHsrLnMg+Nyd44f4JbAo 2fyTY0ads63MmfJzJai3w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddugddujedutdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddv jeenucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhesvghish gvnhhtrhgruhhtrdhorhhgqeenucggtffrrghtthgvrhhnpeejhfevhedttefgfffhhfef fefggffhffelgfeiueeukeehvdehvdefheffvdefueenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdr ohhrghdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoh epphhgshhqlhesjhdquggrvhhishdrtghomhdprhgtphhtthhopehnrghthhgrnhgusgho shhsrghrthesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrh hssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 13 Jun 2025 01:22:15 -0400 (EDT) Message-ID: <2ca8a35d-4bba-4529-88c1-3ca92dbc9e87@eisentraut.org> Date: Fri, 13 Jun 2025 07:22:13 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_dump --with-* options To: Jeff Davis , Nathan Bossart Cc: pgsql-hackers References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <17f63ecf-679c-4337-817f-908bb159701f@eisentraut.org> <350edd98-7e91-4b63-b393-ba8b681b0799@eisentraut.org> <8f4dc84b52165fa31402259b2ab45ae7a04dff42.camel@j-davis.com> Content-Language: en-US From: Peter Eisentraut In-Reply-To: <8f4dc84b52165fa31402259b2ab45ae7a04dff42.camel@j-davis.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12.06.25 23:20, Jeff Davis wrote: > On Thu, 2025-06-12 at 21:16 +0200, Peter Eisentraut wrote: >>> Do we have other options that are order-sensitive? >> >> I think most of them are.  For example: >> >> psql -p 5432 -p 5433 >> initdb --data-checksums --no-data-checksums >> postgres --shared-buffers=1GB --shared-buffers=2GB > > Interesting. I don't think the "last option wins" model applies to > other pg_dump options, though. For instance, in PG17: > > pg_dump --data-only --schema-only > pg_dump: error: options -s/--schema-only and -a/--data-only cannot be > used together > > I don't think it's simple to start using "last option wins" behavior > now. There are probably some combinations of options where it's not > clear whether a later option is an extra constraint or will override a > previous option. It makes sense to raise an error if the specified options cannot be consolidated in an obvious way. I'd expect pg_recvlogical --create-slot --drop-slot to fail, but I'd expect pg_recvlogical --create-slot --slot=foo --slot=bar to work. One of the challenges in the current case is that it is not obvious how --with-data, --no-data, --data-only etc. are connected. If that were clearer, then the way these options should combine or conflict would hopefully follow somewhat naturally.