Re: pg_dumpall --roles-only interact with other options
Zsolt Parragi <zsolt.parragi@percona.com>
From: Zsolt Parragi <zsolt.parragi@percona.com>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: jian he <jian.universality@gmail.com>, wangpeng <215722532@qq.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-02-09T19:46:49Z
Lists: pgsql-hackers
> Is there a reason we need to duplicate these checks in pg_dumpall when they > are already handled by pg_dump? Mainly I think it would be a nicer user experience to fail early without generating additional output other than the error message (currently it writes out 26 lines before the error), but there are also two specific reasons why it would be an improvement: * "--schema-only --no-schema" is already a contradiction before pg_dumpall calls pg_dump: should it print out roles/tablespaces or not? (it doesn't) * if you specify "pg_dumpall --data-only -no-data -f dump.sql", or redirect stdout to a file, it writes out a partial dump before failing, and leaves it there. Users should check error messages and exit codes, but the file is still there and could cause accidents. 3 simple checks could prevent this.
Commits
-
pg_dumpall: Fix handling of conflicting options.
- b2898baaf7e4 19 (unreleased) landed
-
pg_dump: Add dumpSchema and dumpData derivative flags.
- 96a81c1be929 18.0 cited