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

Поиск
Список
Период
Сортировка
От Andrew Bille
Тема Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.
Дата
Msg-id CAJnzarxfQMYjshV3iHp2vizOJx8oPxYEqsWDzVgQJgQq=-WDNA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables.  (Álvaro Herrera <alvherre@kurilemu.de>)
Список pgsql-bugs
Дерево обсуждения
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/

В списке pgsql-bugs по дате отправления: