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 1uRuwo-000iXj-QE for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 15:43:34 +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 1uRuwl-002GtH-LO for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 15:43:32 +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 1uRuwl-002Gt8-Bs for pgsql-hackers@lists.postgresql.org; Wed, 18 Jun 2025 15:43:31 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uRuwj-002mi6-2I for pgsql-hackers@postgresql.org; Wed, 18 Jun 2025 15:43:31 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-73a01a7bee7so2145696a34.1 for ; Wed, 18 Jun 2025 08:43:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1750261408; x=1750866208; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=GcTN/wMw9BqHC5evRhmrbVKdowRKwsevRKExRXxviAs=; b=THQv41imaD/rAMyDEJ9lb5Z6040l9teDNHdhGZHd4N15GCpmHK5GsaAmqspT0R5KD0 KXnWD1uAgIcpDnMBZrpy+PGTliJhHjSW4L0jQ+YE7FE/aVcby5SFh1GMenODKSj9uaG9 hqjkkfrHFZcJKirO2+Bb7nPIK1tTBVFzCNbF6qDai7tgfInP961pnHzxISP6JSop4s1b //2tiRBvCMdXVuvr0rjk6d9FclDaX5PPX/RAtU2ePK6BymU+cad/qFTxcBy0Q1WzewI/ Y4ntjVEI3VQ/4bg/hkp/zV20K3ejBYQosLUtsfqHcaMlkAbaFNURiidgtDoaEqCqtdFy iiwQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750261408; x=1750866208; h=in-reply-to: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=GcTN/wMw9BqHC5evRhmrbVKdowRKwsevRKExRXxviAs=; b=iKunAEcRdFkOSHOXjtojbNp/MZDnaI742L/W3D/Gd3smq+d3tB6jeTO3b/vLn74Ddb 0uLW0FzuMriRNLHAzTT5wH18HBhJoupQVu3B/pnMTD2zLTycyADlDQ9ro9Tsvm5yG7NE UA9+JRi69dAhbkXe3AZiEMBX3XtJSZ5g3Kvz6PgoiTDkuQxTHbfy978eZxvRT+SjI4i+ VDzIG2SNACou/duIeM253e4Dmn632fqLEJGUeZ6gIw8jS61kWOppKDo108VJDVu1MOu4 vnf04T8v5TKOnLdmYRdCiiw784e0xu4foWTpo7e5vsNvv9cVxsWtvEZQAr1SRvonPGfm OhOw== X-Forwarded-Encrypted: i=1; AJvYcCUbKtnf8wDiOv484E0qTpyuu2UCxbKTO0U+e/xTHbdPu3nrAMWuQNI9YDuahJrRx4dZf2ZgIrziJiDLbIhM@postgresql.org X-Gm-Message-State: AOJu0Yw+5Ve04R5Bgh189Y7a+LD6dEtCXHKjL9oLc68w+AGz2SltuWq9 PP46QEEDFu8U18+E4I7ZbhEAAKsj77BAeY9ziiBWta3xIQF1tYwA+3bm X-Gm-Gg: ASbGncvux1X+BJ1U/DqgODTwteWt4fe5YUN30cclDL0PwnsUB1Br98pR3sI6cRQav6m rGCjgtXVS8Q4IvCJU6i2+nLWv9/PLwbFOGg1QtgkEysMJQEyKWGQjrWyMFRS0zKA0q8Iu1DYRSB Iqa8wUCmiNJ+v4T4atF1EM46IB8u5HDUHn6nNchOxzgpupzhrJKBOF6qPetZvFXAk5CjqADkM4/ e5HnFrq3KEB6ZLV848G2TIO8yrGZX8YUy0cnc5oEz32PnBRqI/II/cbUvPJSdwcVLA6JsksM+Jl eIawj48/uWuMMi7BkHyt1HraSAqZyhrAlUa/F0sJSGxI+anzKZT7SxwaljpieRJHPZ+ljz+XsQm 3CZUA/miqR/ZOHytqBtONSeKY3i2NbgUB/UG/fvTtJMAuvx94XjAY7JfD2MIecEFjO7Kd X-Google-Smtp-Source: AGHT+IEyt7Z1tIgsEYdLvB20njtVtJiPdNGIrqQQJnzcniLdzmLDJg/fZBEasZsijSxAWZm/4+06Vw== X-Received: by 2002:a05:6830:808a:b0:72b:9b1f:2e33 with SMTP id 46e09a7af769-73a363218ecmr9659989a34.18.1750261407784; Wed, 18 Jun 2025 08:43:27 -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-50149c85c1asm2800571173.111.2025.06.18.08.43.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Jun 2025 08:43:27 -0700 (PDT) Date: Wed, 18 Jun 2025 10:43:25 -0500 From: Nathan Bossart To: Jeff Davis Cc: 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=us-ascii Content-Disposition: inline In-Reply-To: <5e398522803da9bf3f9fc33ca43084ec21ab0fcd.camel@j-davis.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 18, 2025 at 08:29:16AM -0700, Jeff Davis wrote: > Actually, I take that back, we can't just remove --no-statistics. > Remember that statistics currently default to "on" for pg_restore even > though they default "off" for pg_dump. > > So pg_restore still needs a way to turn stats off. 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. How does that sound? -- nathan