Search Postgresql Archives

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

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

 



On 7/1/21 9:24 PM, W.P. wrote:
W dniu 01.07.2021 o 22:27, Adrian Klaver pisze:
On 7/1/21 12:56 PM, W.P. wrote:
W dniu 01.07.2021 o 16:19, Laurenz Albe pisze:
On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote:
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).

How can I (?) repair this table? (for recent data this works OK).
If you have a backup, take that.

If not, hire an expert in data recovery.

Yours,
Laurenz Albe

I have something similar to backup: old database, but it is 9.5, how can I install 9.5 binaries / libs / config on Fedora 30 i386 (with PG11 installed) side-by-side?

Is the old database on another machine where it can be started and then the data dumped?

It is on another disc, with OS that has problems (F24 does not boot beyond single user mode, Network Manager doesn't start) after removing power / battery while in "suspend to RAM".

Thats why I think about setting 9.5 on my current machine (F30/PG11 cluster) and then do a dump, only I need to know how to do it (binaries / libs / default cfg + data copy).


So you have backup of the failed machine's disk stored somewhere else?

Otherwise how are you going to get the 9.5 instance to the new machine?



Laurent






--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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