Re: pg_dump --with-* options
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut
<peter@eisentraut.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-08-01T19:42:16Z
Lists: pgsql-hackers
Attachments
- v3-0001-Simplify-options-in-pg_dump-and-pg_restore.patch (text/x-patch) patch v3-0001
On Tue, 2025-07-29 at 11:24 -0700, Jeff Davis wrote: > On Wed, 2025-06-18 at 10:21 -0700, Jeff Davis wrote: > > On Wed, 2025-06-18 at 10:43 -0500, Nathan Bossart wrote: > > > IIUC the current proposal is to: > > > > > > * Dump/restore stats by default. > > We don't have a consensus for that, so unless a few people make an > abrupt turnaround, this will remain off for v18. > > > > * 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. > > The other parts of the proposal are very similar with mine below: > > > * delete the --with-data and --with-schema options as unnecessary > > * (maybe?) rename --with-statistics to --statistics > > * keep --no-statistics, --no-data, --no-schema (or use "without" > > instead?) > > * (maybe?) keep --statistics-only > > * reject the combination of an "only" option and a "with" option Patch attached. * removes --with-data and --with-schema (redundant) * renames --with-statistics to just --statistics I kept --statistics and --no-statistics for both pg_dump and pg_restore, because: (a) I think it's good to have consistent options between those two programs; and (b) it allows us to potentially change the default to include statistics in the future. That leaves some redundancy of the options, which some have expressed annoyance over, but it doesn't seem like a major point of objection. Regards, Jeff Davis
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Simplify options in pg_dump and pg_restore.
- 6a46089e458f 19 (unreleased) landed
- a3e8dc143862 18.0 landed
-
pg_dump: reject combination of "only" and "with"
- 0ed92cf50cc4 19 (unreleased) landed
- 60121890f7f2 18.0 landed
-
Change pg_dump default for statistics export.
- 34eb2a80d5a3 18.0 cited