Horton

Re: bug: pg_dumpall with --data-only and --clean options is giving an error after some dump

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Mahendra Singh Thalor <mahi6run@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-03-15T12:11:00Z
Lists: pgsql-hackers 
Hi,

On 2026-Mar-15, Andrew Dunstan wrote:

> On 2026-03-14 Sa 3:18 PM, Mahendra Singh Thalor wrote:
>
> > I was doing some tests with pg_dump, pg_dumpall and pg_restore tools.
> > With "pg_dumpall --data-only --clean", we are reporting an error after
> > dumping some data.
> 
> Hmm, this looks like behaviour that goes a long way back. Should we
> backpatch this fix?

IMO it would make sense to do so.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/

Commits

  1. pg_dumpall: Fix handling of incompatible options.