Horton
Menu

Re: pg_dump --with-* options

Nathan Bossart <nathandbossart@gmail.com>

View thread
From: Nathan Bossart <nathandbossart@gmail.com>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, pgsql@j-davis.com
Date: 2025-06-06T15:39:56Z
Lists: pgsql-hackers 
On Fri, Jun 06, 2025 at 09:14:32AM +0200, Peter Eisentraut wrote:
> We have
> 
>   -a, --data-only      dump only the data, not the schema or statistics
>   --no-data            do not dump data
>   --with-data          dump the data  # this one is new
> 
> (and there is also --section=data), and then three analogous options for
> "schema" and "statistics".
> 
> What is the purpose of the --with-data option?  Dumping the data is the
> default.  Is this to override an earlier --no-data option?

I believe the idea is that these will allow folks to be explicit about what
they want instead of needing to understand the defaults for every
component.

-- 
nathan

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.