Horton
Menu

Re: pg_dump --with-* options

Corey Huinker <corey.huinker@gmail.com>

View thread
From: Corey Huinker <corey.huinker@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Fujii Masao <masao.fujii@oss.nttdata.com>, Nathan Bossart <nathandbossart@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-06-14T02:42:05Z
Lists: pgsql-hackers 
>
>
> Good point. Now that we are getting rid of some of the other options,
> we don't need to worry about consistency with them, and I think we
> should just use "--statistics".


The point of the --with flags was to future proof commands to preserve
behavior in case the defaults ever changed.

This would all be a lot simpler, and the --with switches would all be
unnecessary, if we didn't decide to make exactly one type of dumpable
object (statistics) off by default but only in one of the three commands
(pg_dump).

I think we're creating lasting confusion for the sake of short-term
convenience.

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Simplify options in pg_dump and pg_restore.

  2. pg_dump: reject combination of "only" and "with"

  3. Change pg_dump default for statistics export.