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

On 7/1/21 9:24 PM, W.P. wrote:
> 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).
> 

So you have backup of the failed machine's disk stored somewhere else?

Otherwise how are you going to get the 9.5 instance to the new machine?


> 
> Laurent
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com