Re: Damaged (during upgrade?) table, how to repair? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Damaged (during upgrade?) table, how to repair?
Date
Msg-id 0c827ef91e60470588d5ff4fe4394abb2ec8509d.camel@cybertec.at
Whole thread Raw
In response to Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
Responses Re: Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Greatest of a list of columns?
Next
From: Ron
Date:
Subject: EXPLAIN with anonymous DO block?