Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Damaged (during upgrade?) table, how to repair?
From: "W.P." <laurentp@xxxxx>
Date: Thu, 1 Jul 2021 10:56:05 +0200
User-agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Damaged (during upgrade?) table, how to repair?
  - From: Laurenz Albe

Prev by Date: Must be superuser to create subscriptions - Any way I can avoid using superuser
Next by Date: Insert/Dump/Restore table with generated columns
Previous by thread: Must be superuser to create subscriptions - Any way I can avoid using superuser
Next by thread: Re: Damaged (during upgrade?) table, how to repair?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux