Last active 1723306495

This gist provides contextual copy paste options for Distribution upgrades with installed Zammad and PostgreSQL for Debian (10, 11, 12) and Ubuntu (18, 20, 22). Video context to this: https://youtu.be/IXp4VWU27wo

Revision 38dee943d0ff926223a7d3d3cc23f5623180b0f7

1-general-prerequisites-before-upgrade.sh Raw
1systemctl disable zammad --now
2apt-mark hold zammad
3apt update
4apt upgrade
5
6# Continue with step 2 or 3 depending on your current state
2-debian-10-to-11-repositories.sh Raw
1sed -i 's/debian-security buster\/updates/ bullseye-security/g' /etc/apt/sources.list
2sed -i 's/buster/bullseye/g' /etc/apt/sources.list
3sed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
4sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list
5
6apt clean; apt update
7apt upgrade
8apt dist-upgrade
9
10pg_dropcluster --stop 13 main
11pg_upgradecluster 11 main /var/lib/postgresql/13/
12
13apt autoremove
14shutdown -r now
2-ubuntu-18-to-20-repositories.sh Raw
1sed -i 's/bionic/focal/g' /etc/apt/sources.listsed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
2sed -i 's/ubuntu 18/ubuntu 20/g' /etc/apt/sources.list.d/zammad.list
3apt clean; apt update
4apt upgrade
5apt dist-upgrade
6
7pg_dropcluster --stop 13 main
8pg_upgradecluster 11 main /var/lib/postgresql/13/
9
10apt autoremove
11shutdown -r now
3-debian-11-to-12-repositories.sh Raw
1sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list
2sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list.d/pgdg.list
3sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list
4apt clean; apt update
5apt upgrade
6apt dist-upgrade
7
8pg_dropcluster --stop 13 main
9pg_upgradecluster 13 main /var/lib/postgresql/15/
10
11apt autoremove
12shutdown -r now
3-ubuntu-20-to-22-repositories.sh Raw
1sed -i 's/focal/jammy/g' /etc/apt/sources.list
2sed -i 's/ubuntu 20/ubuntu 22/g' /etc/apt/sources.list.d/zammad.list
3apt clean; apt update
4apt upgrade
5apt dist-upgrade
6
7pg_dropcluster --stop 13 main
8pg_upgradecluster 13 main /var/lib/postgresql/15/
9
10apt autoremove
11shutdown -r now
4-finish-upgrade.sh Raw
1apt-mark unhold zammad
2systemctl enable zammad
3apt update
4apt install zammad