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

From Adrian Klaver
Subject Re: Damaged (during upgrade?) table, how to repair?
Date
Msg-id b20dacdb-67dd-5181-361e-3f28900ffdb2@aklaver.com
Whole thread Raw
In response to Re: Damaged (during upgrade?) table, how to repair?  ("W.P." <laurentp@wp.pl>)
Responses Re: Damaged (during upgrade?) table, how to repair?
List pgsql-general
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 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 disc, with Fedora24 and Postgres 9.5. Then 
>>> copied "sector by sector" (and resized partitions, volumes, fs) to 
>>> 1TB one. This was my "working" disc.
>>>
>>
>> Just dawned on me, why aren't you working directly from the 1TB disk?
>>
>> It has the presumably intact files from before the OS/Postgres 
>> upgrades and the power experiment.
>>
> "Only problem that OS does not boot beyond "emergency mode"."...

I thought the 1TB disk was copied over before you did any of the 
upgrades and experimentation?

> 
> But I made some progress:
> 
> - booted up into single user, bring up Ethernet, now CAN start Postgres 
> but only using pg_ctl directly, does NOT work using systemctl... So 
> problem is (possibly) with systemd.
> 
> Dumped base, pg_dump worked fine, dump gzipped is < 600MB, so I assume 
> that somehow Postgres recovered from my (stupid) move...

Dumped from what Postgres instance 9.5 or 11?

> 
> 
> BTW, pls respond only to list.

Afraid that will be hard to achieve as I my muscle memory is hard wired 
to hit Reply All. If you want to eliminate duplicate copies got to here:

https://lists.postgresql.org/manage/

and check:

Don't receive an extra copy of mails when listed in To or CC fields

and then:

Save

> 
> 
> Laurent
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: "W.P."
Date:
Subject: Re: Damaged (during upgrade?) table, how to repair?
Next
From: "W.P."
Date:
Subject: Re: Damaged (during upgrade?) table, how to repair?