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

Álvaro Herrera <alvherre@kurilemu.de>

From: Álvaro Herrera <alvherre@kurilemu.de>

To: Andrew Bille <andrewbille@gmail.com>

Cc: Nathan Bossart <nathandbossart@gmail.com>, pgsql-bugs@lists.postgresql.org

Date: 2025-10-15T08:56:06Z

Lists: pgsql-bugs

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/