Horton
Menu

Re: pg_dump --with-* options

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: Fujii Masao <masao.fujii@oss.nttdata.com>, Robert Haas <robertmhaas@gmail.com>, Nathan Bossart <nathandbossart@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-07-29T17:41:05Z
Lists: pgsql-hackers 
On Fri, 2025-07-11 at 09:12 +0900, Fujii Masao wrote:
> But to do that, we'd either need to make pg_dump dump statistics
> by default, or allow redundant options like --statistics in
> pg_restore,
> even though it already restores statistics by default.

Redundant options might be annoying, but I don't see them as a major
problem.

> As I understand it, the rough consensus so far is that we'd prefer to
> avoid both of these approaches.

I'm not clear what the consensus approach is, then. Can you elaborate?

> I know some want to change the default
> behavior about statistics in pg_dump, though.

I don't see a consensus to make stats the default.

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 →

  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.