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

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.

To be clear the 1TB disk is working where and with what OS?

>
>
> For test, now I have put it (500GB) in another laptop, then upgraded F24
> to F30 (step by step, once I had to do manually "pg_upgrade", ARAIR this
> was at PG10->PG11 step).

For future reference you can could have gone from 9.5 -> 11 without the
intermediate upgrades.

Also where were you installing Postgres from the Fedora or Postgres repos?

>
>
> Now I did my crazy move, removed battery and power while "suspend to
> RAM". OS (F24! @ 1TB) don't start anymore (beyond "emergency").

I will reserve comment on that move. Still in future it would be prudent
to do a pg_dump and stash the backup somewhere off machine before you do
that sort of experiment.

>
> I use now this upgraded disc (500GB), copying files for daily work from
> 1TB one attached to OPi4.

What I understand from the above is you are copying files from the 1TB
disk to the 500GB disc to work with on the 500GB disk/machine. Am I correct?

>
> Will try, if I can achieve PG9.5 run on that "non working" one. If so,
> and dumpall is OK, then files on this are mainly intact (except for
> NetworkManager)...

In that case you will be using 9.5 pg_dump(all) to do the dump, Assuming
it works it is not guaranteed that it will restore forward to Postgres 11.

>>
>> This will require installing development packages on your new machine.
>>
> Ok, should be easy :)
>
> But what PREFIX should I use during configure step?
> "/usr/lib/postgresql/"? And what about location of config files?

The default for a source compile install is
/usr/local/pgsql(https://www.postgresql.org/docs/11/install-procedure.html).
I would stick with that if for no other reason then helping identifying
your package and source clusters.

>
>
>>>
>>> (I can see PG10 somewhere in /usr/pgsql/postgresql-10/ - bin, lib,
>>> share, postgresql-9.6 is empty).
>>
>> Where do you see the above, old machine or new machine?
>>
> 500GB disc, after system upgrade.

So those where the intermediate updates as you hopped through the
OS/Postgres versions.

>
>
> Laurent
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com