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

From: "W(dot)P(dot)" <laurentp(at)wp(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Damaged (during upgrade?) table, how to repair?
Date: 2021-07-02 17:18:12
Message-ID: cd686a45-8a27-a1a0-da79-b2fec00d6d9b@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:
> 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?

No, I have disc from this machine, looks not damaged (random files).
Only problem that OS does not boot beyond "emergency mode".

>
> Otherwise how are you going to get the 9.5 instance to the new machine?
>
In modern Postgres I've seen there is possibility to have several
(different versions) "clusters" on same machine.

My question (for now) is how to do it?

(I can see PG10 somewhere in /usr/pgsql/postgresql-10/ - bin, lib,
share, postgresql-9.6 is empty).

Laurent

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-07-02 19:05:58 Re: Damaged (during upgrade?) table, how to repair?
Previous Message Tom Lane 2021-07-02 15:22:32