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 1uRuj5-000fGR-9A for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 15:29:23 +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 1uRuj3-002AxS-AB for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 15:29:21 +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 1uRuj2-002AxK-Ta for pgsql-hackers@lists.postgresql.org; Wed, 18 Jun 2025 15:29:21 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uRuj1-002iRa-11 for pgsql-hackers@postgresql.org; Wed, 18 Jun 2025 15:29:20 +0000 Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-234d366e5f2so94784075ad.1 for ; Wed, 18 Jun 2025 08:29:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1750260558; x=1750865358; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=a/iODAgUlSP8F7vfhD+e0neUluOIdXSazrYgcf643OU=; b=YDGJwL8o2Hqx/wtlHNlO22Wf/cdyIWL39ndUBKMuYBTggolo3gyo5Sr5y+9A0wnfP9 vFZIipEnLZR6MBAD5PmDJmy6Oe3w8y0BPRdCTnXQgKd2I/vitVm+dcXgc0Fh2X5bPFgN oHsM8JV83B+1VlKGyWcApSY6IJoKBKvPgy2TarFGSJWsBxg9JFyShUS19Fc7jAjhU3MK xm5Hh46L7m5OF6EvPjHoUM7N/D4qkEAY67NAFphU6wENJ4QKGh9w4lM+5QL/ysqypd2+ Orxxsg7MWrBvbNHWfrdzYDLg7MgR8WHIIwuzmUOjDgo0pq0SGZX00pdsxICtWX4/skLi WkSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1750260558; x=1750865358; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=a/iODAgUlSP8F7vfhD+e0neUluOIdXSazrYgcf643OU=; b=DVLktvW7IGOwJS1UyIfU/e+lwBKurJ0boxJfwg6REqJgtjfMzSx9EAeLSAo9+ce1Xg STwPsrmImFEiC4Z3aZK1TVsRvgC+OnFihOUaYO3YAv/ZRU82j7ZtI1yEX2d7hllDjkup 4DlTbsgmaF8cVbCCmBNym1CH5CTEhCh/C5Bv0I5JA+vAupsaP8PXA363aHW0WiiBh9LK VMqQe+LfBEcjWZ/+iTIdibbCdkd2jMBYELdoKHzZlDJf0WOjdGBPBaRLOho1+yofIySY qnTRmrexZwL90ox2HrC8B6G8IZQbPTOg4HAIrsKp/DHMTxCAHj32nDLK3fQFjfJ4H81f 1oYA== X-Forwarded-Encrypted: i=1; AJvYcCUj4Arl7QjDbtO8qgPeIkE1m1ucK1TqA9IkWEGbUxPX/CfvDOsj8cQKLq9I8+iGDQWN8veLbmwx9jEQyEnI@postgresql.org X-Gm-Message-State: AOJu0Yxd9xGiFmpJuYhxkVt65YM4cdHIGF9ev6/S8olM/CSUlCKi9L32 Pw8w+z/V21MQfmf49PYWdmN1toFlFXfIg6nZXAHKm0LddjaDBXGa/rZZJXE6N/5o6g== X-Gm-Gg: ASbGnctl8X7ZFkZJWKhSkg6PeCUBff7XT20+ydif65G8BQzlA+Y7bmRLtV/lA5ldXZP 90Xz1msB1GSDyFvCorA3Exl8aV3SLO8QaCmzSwpGjZ3463p3jkSh7G5hMSWkdZ/JanhZis7tde9 MPbkAbqBTHjJVmZPbhJ+99zQdPII8uHLY8/cOMF6YsAT1S8vnbSQII2I5lMpKPvmGdB2COqK0ex DQpB/44PkZgsyuDhn9ro9bitdBJldsxwTlHTzUY5h9v27y0TSCf6Eh89Q50KGlmNhIFV9CWJfYq 0UkDSm7jXuuKQmxn0Lac4ixraC23SwzxN0nfGzTMrbHjtzwDzdHdnkD5KHD/xA/QIBv57pp4tkv IjgCp2+ilaBSQSKnoRgSeThocNbo3Wvhl X-Google-Smtp-Source: AGHT+IFZkuPNLNClGmwfStvpypPWfrUxuh+bpzqBa+BrIxs8p5Q8fpK3XP/KKV172AI08WBMRH0x5w== X-Received: by 2002:a17:902:e851:b0:234:f580:a15 with SMTP id d9443c01a7336-2366b329f7cmr285283775ad.14.1750260558186; Wed, 18 Jun 2025 08:29:18 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2365deb0fc2sm101157975ad.180.2025.06.18.08.29.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 18 Jun 2025 08:29:17 -0700 (PDT) Message-ID: <5e398522803da9bf3f9fc33ca43084ec21ab0fcd.camel@j-davis.com> Subject: Re: pg_dump --with-* options From: Jeff Davis To: Nathan Bossart , Robert Haas Cc: Peter Eisentraut , pgsql-hackers Date: Wed, 18 Jun 2025 08:29:16 -0700 In-Reply-To: <7bf0246542713d80f12c738c1d365d1365750c18.camel@j-davis.com> References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <7bf0246542713d80f12c738c1d365d1365750c18.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-06-12 at 08:58 -0700, Jeff Davis wrote: > On Thu, 2025-06-12 at 09:52 -0500, Nathan Bossart wrote: > > If the idea is to remove all options for default behavior, we'd be > > removing > > --no-statistics, --with-data, and --with-schema at this point. >=20 > That's OK with me. 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. Regards, Jeff Davis