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@xxxxxxxxxxx
