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

From Adrian Klaver
Subject Re: Damaged (during upgrade?) table, how to repair?
Date
Msg-id e8399909-85db-af68-3bd3-febdbc4bfd72@aklaver.com
Whole thread Raw
In response to Re: Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
Responses Re: Damaged (during upgrade?) table, how to repair?
List pgsql-general
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?

> 
> 
> Laurent
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: "W.P."
Date:
Subject: Re: Damaged (during upgrade?) table, how to repair?
Next
From: Craig Ringer
Date:
Subject: Re: PGDLLIMPORT: patch or not to patch