Re: pg_dump --with-* options - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: pg_dump --with-* options
Date
Msg-id CAKAnmm+JwDEKTw_wm6ODnwTwMv=ajD+-Ay81_Md0LqeeanwQ3A@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump --with-* options  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: pg_dump --with-* options
List pgsql-hackers
On Wed, Jun 18, 2025 at 11:43 AM Nathan Bossart <nathandbossart@gmail.com> wrote:
IIUC the current proposal is to:

* Dump/restore stats by default.
* 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.

This is so close to ideal. It's just that the first bullet should be "off by default" :)

I think pg_restore and pg_upgrade are solved problems at this point. I'm still not convinced why stats should be on by default, as they are metadata - neither schema nor data, but something special that should be explicitly requested. Also, +1 to the idea of --statistics-only as a QA / debug tool as someone mentioned upthread.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson