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

W dniu 01.07.2021 o 22:27, Adrian Klaver pisze:
> On 7/1/21 12:56 PM, W.P. wrote:
>> 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?
>
> Is the old database on another machine where it can be started and 
> then the data dumped?
>
It is on another disc, with OS that has problems (F24 does not boot 
beyond single user mode, Network Manager doesn't start) after removing 
power / battery while in "suspend to RAM".

Thats why I think about setting 9.5 on my current machine (F30/PG11 
cluster) and then do a dump, only I need to know how to do it (binaries 
/ libs / default cfg + data copy).


Laurent