Horton

Re: pg_dumpall dumps global objects with --statistics-only or --no-schema

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es
From: Jeff Davis <pgsql@j-davis.com>
To: Corey Huinker <corey.huinker@gmail.com>, Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-07-16T17:03:44Z
Lists: pgsql-hackers 
On Mon, 2025-06-30 at 16:44 -0400, Corey Huinker wrote:
> > 
> > Since pg_dumpall treats global objects as schema-level content, it
> > currently
> > includes them with --schema-only but skips them with --data-only.
> > By that logic,
> > it should also skip them when either --statistics-only or --no-
> > schema is used.

Thank you.

> 
> +1, pending resolution of the defaults issue.

I went ahead and committed this as it clearly needs to be fixed. We can
continue the options discussion.

Regards,
	Jeff Davis

Commits

  1. pg_dumpall: Skip global objects with --statistics-only or --no-schema.