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

2021-07-05 Thread Sam Gendler
On Sun, Jul 4, 2021 at 1:20 PM Adrian Klaver wrote: > > In any case I don't see you getting a 9.5 version on the laptop in the > package directories. Pretty sure the Fedora 30 repos will not have 9.5 > and the Postgres repos don't go back to Fedora 30. So if you want a 9.5 > instance you will

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

2021-07-04 Thread Adrian Klaver
On 7/4/21 12:29 PM, W.P. wrote: >> So you have backup of the failed machine's disk stored somewhere else? To be clear the 1TB disk is working where and with what OS? 1TB DISC is connected to OrangePi4 (as I have copied disc "sector by sector" from 500GB to 1TB, some months ago, I can't

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

2021-07-04 Thread W.P.
W dniu 04.07.2021 o 21:10, Adrian Klaver pisze: On 7/4/21 11:59 AM, W.P. wrote: W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:

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

2021-07-04 Thread W.P.
>> So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that OS does not boot beyond "emergency mode". I would say your second sentence contradicts your first. Nope ;). There was 1 500GB

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

2021-07-04 Thread Adrian Klaver
On 7/4/21 11:59 AM, W.P. wrote: W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk

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

2021-07-04 Thread W.P.
W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I

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

2021-07-04 Thread Adrian Klaver
On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged

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

2021-07-04 Thread Adrian Klaver
On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged

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

2021-07-04 Thread W.P.
W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that

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

2021-07-02 Thread Adrian Klaver
On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that OS does not boot beyond "emergency mode". I

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

2021-07-02 Thread W.P.
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: 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)

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

2021-07-02 Thread Adrian Klaver
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

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

2021-07-01 Thread W.P.
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

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

2021-07-01 Thread Adrian Klaver
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

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

2021-07-01 Thread W.P.
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 maximum is yyy"

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

2021-07-01 Thread Laurenz Albe
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 maximum is yyy" (from memory). > > How can I (?) repair

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

2021-07-01 Thread W.P.
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 maximum is yyy" (from memory). Also fails pg_dumpall. How can I (?) repair this table? (for

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

2021-07-01 Thread W.P.
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 maximum is yyy" (from memory). Also fails pg_dumpall. How can I (?) repair this table? (for