Horton

Re: pg_dumpall --roles-only interact with other options

Zsolt Parragi <zsolt.parragi@percona.com>

View thread View on postgr.es
From: Zsolt Parragi <zsolt.parragi@percona.com>
To: jian he <jian.universality@gmail.com>
Cc: wangpeng <215722532@qq.com>, Nathan Bossart <nathandbossart@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-02-04T19:20:14Z
Lists: pgsql-hackers 
Hello!

Should these work? (currently these don't result in errors, but
doesn't seem to be useful in practice)

pg_dumpall --globals-only --no-schema
pg_dumpall --globals-only --data-only

Also previously the code had a check that certain flags
(--statistics-only, --data-only, --no-schema) didn't dump roles and
tablespaces. With the current patch, this is no longer true, and that
doesn't seem to be an intended change, at least it's not explained in
the commit message. The removed condition that causes this was already
mentioned previously, but without explicitly stating that this results
in a behavior change.

Commits

  1. pg_dumpall: Fix handling of conflicting options.

  2. pg_dump: Add dumpSchema and dumpData derivative flags.