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: Damaged (during upgrade?) table, how to repair?
Date: 2021-07-01 08:56:05
Message-ID: 7a242c24-6bc7-2800-a857-6fbe8633382b@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

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).

Also fails pg_dumpall.

How can I (?) repair this table? (for recent data this works OK).

Laurent

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zickzack 2021-07-01 10:06:47 Insert/Dump/Restore table with generated columns
Previous Message Avi Weinberg 2021-07-01 08:43:50 Must be superuser to create subscriptions - Any way I can avoid using superuser