In-place Upgrade from 5.x to PMG 6.0

[DvM]

Hello,

We would like to upgrade from PMG 5.2-7 to version 6.0. (Single Installation - no Cluster!)
The only thing we don't understand is the Postgres upgrade from version 9.6 to 11

Can you please tell us the step by step commands to upgrade our prostgres to version 11?
(Because the wiki entry describes the process for PMG cluster only?)

many thanks!
Dominique

 

[Stoiko Ivanov]

Hi,

The upgrade instructions are for single nodes and clusters alike:
https://pmg.proxmox.com/wiki/index.php/Upgrade_from_5.x_to_6.0

All steps related to PMG clusters are marked as such (as far as i see the work cluster is written in bold)
Maybe the confusion is due to the use of 'postgres cluster'? This is the term Postgres refers to for a Database-system installation
(you can have multiple clusters (of the same or different version) running on one system) - see https://stackoverflow.com/questions/12908205/whats-a-postgresql-cluster-and-how-do-i-create-one

If possible please describe how the misunderstanding came up? (It would help to improve the upgrade instructions for other users)

Thanks!

 

[DvM]

Hi,

this confusion came up because of the Section "Upgrade postgres Database"

Before you upgrade the postgres main cluster, you need to remove the automatically created cluster in the new version.

Where postgres cluster has nothing to do with compute cluster.


if I understood correctly we should run following commands after doing a dist upgrade:

pg_dropcluster --stop 11 main

pg_upgradecluster -v 11 9.6 main

systemctl unmask postfix pmg-smtp-filter pmgpolicy pmgdaemon pmgproxy

reboot

apt purge postgresql-9.6 postgresql-client-9.6 postgresql-contrib-9.6

systemctl unmask pmgmirror pmgtunnel

systemctl start pmgmirror pmgtunnel


correct?

many thanks!
Dominique

 

[Stoiko Ivanov]

That's what we used here many times successfully
As always - create a backup before!

 

[DvM]

I will, thank you !

 

[DvM]

Version 6.0-4 is up and running, many thanks to the Proxmox Team!

Just finished my installation with cleaning up some old kernels

 

[Stoiko Ivanov]

Thanks for the (positive) report

 

[Florian Bauer]

Hello, I have a simular problem ... I use the old version 5.0-61, by pmgupgrade i will upgrade to 5.2.7 - and then i use the same upgrade todo https://pmg.proxmox.com/wiki/index.php/Upgrade_from_5.x_to_6.0 but after the last reboot nothing happen - it will not boot into the webinterface. any idea or may me help someone? thx

 

[Stoiko Ivanov]

Hmm - check the journal (ssh into PMG and run `journalctl -r`) that should provide some hint what is not working

I hope this helps!

 

[Florian Bauer]

hello yes i'm on a production System - so i must do it at evening.
is there a supported way to upgrade from my Version 5.0-61 to 6.x?
or a Company, which will help us (for a fee)?

 

[Stoiko Ivanov]

The wikipage you pasted (https://pmg.proxmox.com/wiki/index.php/Upgrade_from_5.x_to_6.0) contains the supported upgrade path.
The upgrade to the latest 5.2.7 is necessary.
Alternatively you can also install a new PMG 6.1 and restore a backup taken from 5.0 (the quarantine will not be restored, and you need to adapt the network settings)

We offer support while troubleshooting via our Enterprise Support Portal (https://my.proxmox.com) to Customers who have a Subscription of Level Basic or higher - https://www.proxmox.com/en/proxmox-mail-gateway/pricing
Check the subscription agreement linked there for what is covered by the Support.

I hope this helps!

 

[Florian Bauer]

Thats a good Idea; e new Installation.
i will try this way. ist it possible to use the same license (we have a Basic subcritption)

 

[Stoiko Ivanov]

You can migrate the subscription to the new system by reissuing it in the webshop - see https://shop.maurer-it.com/index.ph...rrent-subscription-key-to-the-new-server.html

 

[Jacky Li]

I did my upgrade in place over the weekend and no problem. First of all, I backup the whole PMG vm. I then did everything via the command line, make sure pmg is up to date: apt update then apt dist-upgrade. I then follow https://pmg.proxmox.com/wiki/index.php/Upgrade_from_5.x_to_6.0 for the rest of the steps.

My PMG 5 is heavily customized with SASL authenticate , opendkim, clamav-unofficial-updates and other spamassasins according to the excellent tutorial by heutger, I turned off dkim service and pass the SASL authentication to another server after the update. So far, I don't see any problems except the forward emails. Forward emails broke the SPF and cause the DMARC_REJECT on spamassassin with a score of 10. I have a rule to monitor outgoing SPAM emails and notify me. I installed postsrsd to fix it.

The mail-filter is really nice and powerful.

Jacky

 

[Florian Bauer]

Everything OK

Reinstall as a new Installation, restore the Backup and changes the network-address.
The Migration of the license done.

Thank you