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

Thank you, that case has already been resolved, and the data has been
recovered.
System reindex and vacuum full didn't help.
The schema and indexes were not needed, a modified pg_dump helped us.


On Wed, Oct 15, 2025 at 3:56 PM Álvaro Herrera <alvherre@kurilemu.de> wrote:

> 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/
>