Re: Damaged (during upgrade?) table, how to repair?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Damaged (during upgrade?) table, how to repair?
Дата
Msg-id 0c827ef91e60470588d5ff4fe4394abb2ec8509d.camel@cybertec.at
обсуждение исходный текст
Ответ на Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
Ответы Re: Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
Список pgsql-general
On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote:
> I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS upgrade).
> 
> One table is now damaged, trying to dump it results in server restart, 
> message is "invalid record length xxxx maximum is yyy" (from memory).
> 
> How can I (?) repair this table? (for recent data this works OK).

If you have a backup, take that.

If not, hire an expert in data recovery.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Greatest of a list of columns?
Следующее
От: Ron
Дата:
Сообщение: EXPLAIN with anonymous DO block?