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 1uPoz0-00GgVC-BB for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:57:10 +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 1uPoyx-00FzWh-JC for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:57:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uPoyx-00FzWY-9N for pgsql-hackers@lists.postgresql.org; Thu, 12 Jun 2025 20:57:07 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uPoyv-001fej-27 for pgsql-hackers@postgresql.org; Thu, 12 Jun 2025 20:57:06 +0000 Received: by mail-io1-xd2c.google.com with SMTP id ca18e2360f4ac-86a464849c2so54700539f.1 for ; Thu, 12 Jun 2025 13:57:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749761824; x=1750366624; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=7ji+VUjvLNeHCJHhvAxMPm42EYdqlJ61fD1A5JhxA9E=; b=cuLUUzJu6Zux9Po3ytZRnX3YPdNQXH2HqmVMac5t9qiTPXwlbERXZ7Re+Pk5TADK21 Dh5+EDRkStsRPQF/ZxncaFf6eX4HdKBOh0KpYE5/jfHGJz2W6/awHX0LAz5Xjpf3x989 HFEJwRT7QCfe/ESbT4CqX3wKLB0ct/ziwNrTG9ps4opUCJ2G7HFukKl5tHbUKnIrMLke tcucWgwnqSm+/oyf66sYKZkMikCZetBczkdpGhxhOHDvYCMncCLV4oSy7lrKGo3bLkWz ZExoCfmfhcG8Sih+D5H7qcXZrD9NC/hXNPD8AR3rgc9yIeBcgvX9w32yDFkidZ9jdd4N PMBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749761824; x=1750366624; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=7ji+VUjvLNeHCJHhvAxMPm42EYdqlJ61fD1A5JhxA9E=; b=o+dozC1feWvTSZJOkDwGgKV407/eQOa3fnGpCAlcxSAr6XtuGH6xmgDGN+GMZ4kneD Mz1E0IwJ4WBCAiyTDBgavf+lP4WNHUzvsg35MBRmz7xhWiL8V92w51/hodxZhopae4/v SQD6K+7rvm6HbtGReepAD6XfD7/WauvHTFqaRdOVmLhVK7usIkIROkePHtFpg8vqg2UW TgdWuxBHZdXzEXg7+AWqbBTIrFjS4Awbll1/0dj9wHu+N8oFgQmhYNfHmvSVlCgj2E/a 105YssEUS8iMeo9mIHf+SAwtf6MwgJmhV34gbvp6gyS7lltqaGFtkx0/XdKke+221Lgf iUVw== X-Forwarded-Encrypted: i=1; AJvYcCXWkAOVrQ2D8Lm8fBDg5T0J6uRivjU7pKifl7hGkyX4zur0vJRIar9ZeEVmQXHTJ1REOquUn4ktWdEZrNn4@postgresql.org X-Gm-Message-State: AOJu0Yxob+FqRl6FBpp5w4bTr5toHc3PG3qGFcLz3IW3g3MD9TtsjblN SAbOt8ZrKLOviK7nY14jkVj697jPHmCdg1/30sulft5Vqt+UgtsvjvOy X-Gm-Gg: ASbGnct16a0vD9LcrrIsZcdqDdgqcycVC7sUkoQ/qWvV25uCru9+80Honh7Zbsmao+E 6TxYZHKBre0VXHCza2g1vPd8ZAkBvgFhYIal82kgQq+xYYS3Qchygw6hXdxDqpU0wrvEOhN7I76 XAgfKH2Gf13NnnWZ8hPPAu6eNSF+FObtf2ij4yLgilqhuiWAvZ0bbWzYR4HxlPDeMMKr4tieUtk QrIb73l9a11fKME0WfrIvQs2wGjkXm7rA85FJt9IW7Cs683uEoSppkXngUFgpg++GZ13O79A+jq f+PHiv2NWzJyb8FjcJhzBX8LzrH6+p4YaZdIIX/r+1EjXQTi2yWdnYfnGTVaPqIIuFLOIh0pCGx 1dnWR43uqprFW0Mzn+V4AAaQCWPID7zCXnLrxKZ0YZQYmazssPUU/ X-Google-Smtp-Source: AGHT+IGXiDRP2a0kkvmqZ0jjnDofU59RosRRyGJHDNpdfI+sC5SqgAUg4RtAnhBDsGclSJocBIm8vw== X-Received: by 2002:a5e:a903:0:b0:867:15a5:d16 with SMTP id ca18e2360f4ac-875c68bf33emr407280339f.8.1749761823975; Thu, 12 Jun 2025 13:57:03 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-5013b8fbe52sm445642173.131.2025.06.12.13.57.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Jun 2025 13:57:03 -0700 (PDT) Date: Thu, 12 Jun 2025 15:57:01 -0500 From: Nathan Bossart To: Corey Huinker Cc: Robert Haas , Jeff Davis , Peter Eisentraut , pgsql-hackers Subject: Re: pg_dump --with-* options Message-ID: References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <7bf0246542713d80f12c738c1d365d1365750c18.camel@j-davis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 12, 2025 at 04:39:00PM -0400, Corey Huinker wrote: > On Thu, Jun 12, 2025 at 4:22 PM Nathan Bossart > wrote: >> I do think this is useful functionality, I only suggested removing it >> because AFAICT it is redundant, i.e., you can accomplish the same thing >> with --with-statistics --no-schema --no-data. It seems like we're trying >> to avoid having multiple ways to do the same thing. > > By that same argument, we should remove --schema-only and --data-only as > well. I think we shouldn't because those two options have proved very > convenient for users and they convey clear intent to the person reading the > script, and I believe that --statistics-only will prove the same over time. Those predate v18, so while might be able to mark them deprecated, I doubt we'd remove them anytime soon. FWIW I don't have a tremendously strong opinion about --statistics-only. I'd probably vote to remove it because 1) it's redundant, 2) once you add an option, it's hard to remove it, and 3) pg_dump already has so many options. But I won't cry too hard if we keep it around. -- nathan