New PMG 9 upgrade issues

zimny

Active Member
Jun 17, 2019
29
0
41
52
Hi,

Any one can advice on the safe upgrade procedure for PMG 9.

I have an issue with postgresql

The PMG8to9 reporting me:

FAIL: Running postgres version '11' is not '15', was a previous upgrade left unfinished?

Is it mean that I can safely removing all postgresql prior then 15 packeges ?

This is very old PMG LXC

Thank you in advance
 
I was trying:

sudo -u postgres pg_upgrade -b /usr/lib/postgresql/11/bin -B /usr/lib/postgresql/15/bin -d /var/lib/postgresql/11/main -D /var/lib/postgresql/15/main

and get:

sudo: pg_upgrade: command not found

looks like my PMG LXC using psg 11 for mail filter and psg 15 for other things

lost on it :(
 
Last edited:
Seems you missed upgrading the postgres cluster step in the upgrade-guides from 5->6 , 6->7, 7->8 :
https://pmg.proxmox.com/wiki/Category:Upgrade

It might quite well be possible to upgrade directly from 11 to 15 - but maybe it's easier to create a pmg-backup and restore it on a fresh install of PMG 9.

In any case make sure you a well tested backup of your setup before proceeding.

I hope this helps!
 
Hi thank you for your reply. If I will create backup in PMG then I will not include all this mess in it? All the setup remain the same?
Thank you in advance
 
The backup created inside PMG through the GUI contains:
* your rules and settings
* any changes to the configuration templates
* if selected also the statistics

It does not contain data that is transient - quarantined mails and logs (which are the source of the tracking center)
it also does not contain any changes to the system you did outside of PMG - additional installed software, config files for other packages...
Additionally you need to adapt the network configuration - if you want to run the new PMG with the IP of the current one.

I hope this explains it