Postgres Pro
Downloads
Home   >   mailing lists

Damaged (during upgrade?) table, how to repair? - Mailing list pgsql-general

From W.P.
Subject Damaged (during upgrade?) table, how to repair?
Date
Msg-id d0c0b2e2-56cb-bc55-b3e0-1be1167817f3@poczta.onet.pl
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Connecting to Postgresql without IP address
Next
From: Avi Weinberg
Date:
Subject: Must be superuser to create subscriptions - Any way I can avoid using superuser