Request a Demo
Home   >   mailing lists

Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables. - Mailing list pgsql-bugs

From Álvaro Herrera
Subject Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
Date
Msg-id 202510150855.xloserzoobhu@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.  (Andrew Bille <andrewbille@gmail.com>)
Responses Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
List pgsql-bugs
Tree view 
On 2025-Oct-15, Andrew Bille wrote:

> > Is this a hypothetical problem or something you've experienced?
> 
> The problem is real: when trying to rescue data from a large corrupted
> database, we couldn't wait for the index definition query for more than 3
> hours.

Maybe it'd be reasonable to start the recovery by doing VACUUM FULL of
all/some system catalogs.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/

pgsql-bugs by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: TRAP: failed Assert("outerPlan != NULL") in postgres_fdw.c
Next
From: Andrew Bille
Date:
Subject: Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.