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

From W.P.
Subject Re: Damaged (during upgrade?) table, how to repair?
Date
Msg-id 7775fcc7-b41a-394f-3c58-8960b23dee40@wp.pl
Whole thread Raw
In response to Re: Damaged (during upgrade?) table, how to repair?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Damaged (during upgrade?) table, how to repair?
List pgsql-general
W dniu 01.07.2021 o 16:19, Laurenz Albe pisze:
> 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

I have something similar to backup: old database, but it is 9.5, how can 
I install 9.5 binaries / libs / config on Fedora 30 i386 (with PG11 
installed) side-by-side?


Laurent




pgsql-general by date:

Previous
From: Pavel Luzanov
Date:
Subject: Re: EXPLAIN with anonymous DO block?
Next
From: Adrian Klaver
Date:
Subject: Re: Damaged (during upgrade?) table, how to repair?