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@xxxxxxxxxxxxxx>
Date: Thu, 1 Jul 2021 10:12:23 +0200
Disposition-notification-to: "W.P." <laurentp@xxxxxxxxxxxxxx>
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]

Prev by Date: Insert/Dump/Restore table with generated columns
Next by Date: Re: Insert/Dump/Restore table with generated columns
Previous by thread: Re: Damaged (during upgrade?) table, how to repair?
Next by thread: Insert/Dump/Restore table with generated columns
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