[SOLVED] 6.x to 7.x upgrade PostgreSQL

[XN-Matt]

Following the upgrade guide and getting to the PgSQL part:

root@mx1:~# pg_dropcluster --stop 13 main
Error: specified cluster does not exist
root@mx1:~# pg_upgradecluster -v 13 11 main
Stopping old cluster...
Restarting old cluster with restricted connections...
Notice: extra pg_ctl/postgres options given, bypassing systemctl for start operation
Error: no initdb program for version 13 found
Error: Could not create target cluster

Bit confused as this does not seem to tally with the guide.

 

[t.lamprecht]

Are you sure you upgrade, or in that case installed PostgreSQL already to version 13? As the first command would not suggest so.

Maybe missed to upgrade (some of?) the package repositories to the PMG 7.0 / Debian 11 Bullseye paths?

Can you post the output of pmgversion -v ?

 

[XN-Matt]

Yes, it was the repo issue.

It may be worth making clear note about the non-ent repo as unless you click a link, read fully, that step is going to be overlooked.

 

[t.lamprecht]

Normally one has a repository already setup, as else one wouldn't be able to fulfil the upgrade-precondition to upgrade to the latest 6.4 first, and if that's the case then the sed command would also transform that into a valid accessible bullseye repository for PMG 7.x.

I rather made that more clear in the preconditions, i.e., what version one should have before starting the upgrade and that one may lack package repositories they can access if it seems for them as they cannot upgrade to the mentioned version.

 

[XN-Matt]

I understand although it was in ther before (as it had been updating just fine) and following the steps, to the letter, on four servers, the same issue happened on both.

We've been through the history to confirm no steps were missed, so based on the guide alone, the outcome was not as expected.