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

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.klaver@aklaver.com