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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
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 14:19:25
Message-ID: 0c827ef91e60470588d5ff4fe4394abb2ec8509d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2021-07-01 16:16:25 EXPLAIN with anonymous DO block?
Previous Message Pavel Stehule 2021-07-01 13:28:27 Re: Greatest of a list of columns?