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

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bug: pg_dumpall with --data-only and --clean options is giving an error after some dump
Date: 2026-03-15 12:11:00
Message-ID: 202603151210.2dexp4f652dw@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-03-15 12:18:53 gen_guc_tables improvements
Previous Message Alexander Lakhin 2026-03-15 12:00:00 pgcrypto/des tests fail on riscv64 due to clang's code generation anomaly