Re: vacuumdb produces ERROR: cannot freeze committed xmax

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: vacuumdb produces ERROR: cannot freeze committed xmax
Дата
Msg-id ed38b33f0bc5548b50426df91f91b0d961fb0f0b.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: vacuumdb produces ERROR: cannot freeze committed xmax  (Sbob <sbob@quadratum-braccas.com>)
Список pgsql-admin
On Thu, 2025-11-13 at 10:16 -0700, Sbob wrote:
> Yes, we did a restore of the tables that seemed to be corrupted, any
> advice on determining the cause of the corruption?

Investigate what odd things you did with the database.

In my experience, the main causes for corruption are:

- shoddy or old hardware

- bad administration (e.g., badly taken backups)

- software bugs

Yours,
Laurenz Albe



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