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 1uURES-003Hhm-Uf for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Jun 2025 14:36:12 +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 1uURER-004AIC-0k for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Jun 2025 14:36:11 +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 1uUREQ-004AI4-NK for pgsql-hackers@lists.postgresql.org; Wed, 25 Jun 2025 14:36:11 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uUREP-003wGR-2e for pgsql-hackers@postgresql.org; Wed, 25 Jun 2025 14:36:10 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3df316b5b40so4728665ab.1 for ; Wed, 25 Jun 2025 07:36:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750862169; x=1751466969; 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=T7m7PdxXT6ItElApt78GvUC7KtmpbXsPW4M0vwSTs8I=; b=Vbeq/tzWJZOXoqpSUhuFviohDBA5Vtqx32k8Nj40arHl8vOZqrp/fGYuE2XlYDlri5 XgBs/PSeEaggYFvl82VL5zYVd0mHEnictRuZbdopSxs4A/zwRLxev9TgcLo79T5sWR6u 5cJzidTdCymEjEp6p/OU5rHrGDMpF6h5x/vEUeK8oWgSWlKmANFxbgAgvjZtQ4jbQ+Ub 8d+UHG5QMlc5io0HJSGd/VuhY3PljjiHPRmFZTsj79dSxqKu0CYgoWfviVY4/XlXH7iY 0gRVMge6N2rmT5b5AykrcaUvihy0cDJABQK+JRq+cMljQwgJOOdqLjVdFp8QllC9lu44 I+4g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750862169; x=1751466969; 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=T7m7PdxXT6ItElApt78GvUC7KtmpbXsPW4M0vwSTs8I=; b=IgKtNLM48ZUc2+L9YmhjgywQmlyR52HOXEmqy9cNAGdBuLW3fQcoOlTIfCT1nD/hqO NcmPj9le/saYHYtBwMHfjHq7n2QylcjkcvKOBSPoaKVq8wdw7CFhgBZm0NNJZ4U+gVBe A0PUU9wyhtPL6Dj8x2W/rmaNWKmT71tgZkkS0FN7rYVtL5AhNERpV5Zr6PZFdFiXIAMi YBn+HMb3YgspK/QhHTp8OXhjM+3nRqtrnTzllCUXQrUL4g94SDb9tcc1yOTiIZe+IOfY xzEjBqGWut9IcqOOncTws7JNkrjuJwUABrsnHrAWrRRDe8OkBDEPbHbC3uOZqStb2SYU Wfjg== X-Forwarded-Encrypted: i=1; AJvYcCXsp4tbIi4dfkNwF9p+N3hL2L8nrWkvYsxssaqkY6yWEt3dmiN+xABJ1bcehzyTQaNPePLW7ATG+1YjtStz@postgresql.org X-Gm-Message-State: AOJu0YyNiFvYqxp4yK0jFwME8Wr3VvfnAXInHmOAl5/r/yvJs52XroSi Ya7loD8IVYIrXpbdzeu2ncxXknwBF3cXpsWXJY3YyKtxirsuh8TXjSgU X-Gm-Gg: ASbGnctQwlep7asWaq/0LTf8lhnyirr6xqlK8HKofOwJ6052OSuZK6wTo0iFA3BjtvL pUtPIU2bTvUS7T6WIkW+nGl6w07M2Qau0ZaFZ6eWj7FgEWFTJGqqRqR6JsbEegpnrBYKqfurpay vSgKgJdhP30qFTGJ0u8qNpzCgC3nsh/tTmln5sIdKY9VDXSh/TAM5ZDV6e1wveIiVFhB4pNAwW1 iVXEmsYB/15Gt2LDZT553BtN4E397flB69tvi4OGAgwBuTy9RLstuDfNSD89LuR6W/035kyjt7o RdTujxZLMKHtUaiqyyJVNGvbvy6DlcvrN0h0u6mMUsRb7vsPMrJYZcix5tzghEyAaDCFdvyCd0P aNgUmHAEWYQoU0YCHlD9WWUlFTjNmNPSs0zQ5FFU+4QPkFrEkAI6eRpao3w== X-Google-Smtp-Source: AGHT+IF6tTcHYvvtSCUfLqQUMwagNkMarCkvb9S6Usoekc2kAm9qZsVVpAE3S8FSb4f+mhEKNd5nOA== X-Received: by 2002:a05:6e02:2289:b0:3de:1583:dc2d with SMTP id e9e14a558f8ab-3df3296d5demr39329685ab.11.1750862164142; Wed, 25 Jun 2025 07:36:04 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3df328f838dsm6175835ab.11.2025.06.25.07.36.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Jun 2025 07:36:03 -0700 (PDT) Date: Wed, 25 Jun 2025 09:36:02 -0500 From: Nathan Bossart To: Greg Sabino Mullane Cc: Jeff Davis , Robert Haas , 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> <5e398522803da9bf3f9fc33ca43084ec21ab0fcd.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 Tue, Jun 24, 2025 at 06:14:55PM -0400, Greg Sabino Mullane wrote: > On Wed, Jun 18, 2025 at 11:43 AM Nathan Bossart > wrote: >> IIUC the current proposal is to: >> >> * Dump/restore stats by default. >> * Keep the --no-statistics, --no-schema, and --no-data options. >> * Keep the --statistics-only, --schema-only, and --data-only options. >> * Remove the --with-statistics, --with-schema, and --with-data options. > > This is so close to ideal. It's just that the first bullet should be "off > by default" :) If we did that, the only way to dump statistics would be --statistics-only, right? You wouldn't be able to include statistics along with other things. -- nathan