From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "W(dot)P(dot)" <laurentp(at)wp(dot)pl>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Damaged (during upgrade?) table, how to repair? |
Date: | 2021-07-01 20:27:08 |
Message-ID: | e8399909-85db-af68-3bd3-febdbc4bfd72@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2021-07-02 02:17:24 | Re: PGDLLIMPORT: patch or not to patch |
Previous Message | W.P. | 2021-07-01 19:56:17 | Re: Damaged (during upgrade?) table, how to repair? |