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

From: "W(dot)P(dot)" <laurentp(at)poczta(dot)onet(dot)pl>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Damaged (during upgrade?) table, how to repair?
Date: 2021-07-01 08:12:23
Message-ID: d0c0b2e2-56cb-bc55-b3e0-1be1167817f3@poczta.onet.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

Browse pgsql-general by date

  From Date Subject
Next Message Avi Weinberg 2021-07-01 08:43:50 Must be superuser to create subscriptions - Any way I can avoid using superuser
Previous Message sivapostgres@yahoo.com 2021-07-01 06:33:22 Re: Connecting to Postgresql without IP address