1-general-prerequisites-before-upgrade.sh
· 561 B · Bash
Raw
systemctl disable zammad --now
apt-mark hold zammad
apt update
apt upgrade
# Do once, new since recent psql CVEs
apt install curl ca-certificates
install -d /usr/share/postgresql-common/pgdg
curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc
echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list
# Continue with step 2 or 3 depending on your current state
1 | systemctl disable zammad --now |
2 | apt-mark hold zammad |
3 | apt update |
4 | apt upgrade |
5 | |
6 | # Do once, new since recent psql CVEs |
7 | apt install curl ca-certificates |
8 | install -d /usr/share/postgresql-common/pgdg |
9 | curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc |
10 | echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list |
11 | |
12 | # Continue with step 2 or 3 depending on your current state |
2-debian-10-to-11-repositories.sh
· 596 B · Bash
Raw
sed -i 's/debian-security buster\/updates/ bullseye-security/g' /etc/apt/sources.list
sed -i 's/buster/bullseye/g' /etc/apt/sources.list
sed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list
apt clean; apt update
apt upgrade
apt dist-upgrade
# Current stable psql version is 16
pg_dropcluster --stop 16 main
pg_upgradecluster 11 main /var/lib/postgresql/16/
# Below two are old (pre recent psql CVE)
# pg_dropcluster --stop 13 main
# pg_upgradecluster 11 main /var/lib/postgresql/13/
apt autoremove
shutdown -r now
1 | sed -i 's/debian-security buster\/updates/ bullseye-security/g' /etc/apt/sources.list |
2 | sed -i 's/buster/bullseye/g' /etc/apt/sources.list |
3 | sed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list |
4 | sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list |
5 | |
6 | apt clean; apt update |
7 | apt upgrade |
8 | apt dist-upgrade |
9 | |
10 | # Current stable psql version is 16 |
11 | pg_dropcluster --stop 16 main |
12 | pg_upgradecluster 11 main /var/lib/postgresql/16/ |
13 | |
14 | # Below two are old (pre recent psql CVE) |
15 | # pg_dropcluster --stop 13 main |
16 | # pg_upgradecluster 11 main /var/lib/postgresql/13/ |
17 | |
18 | apt autoremove |
19 | shutdown -r now |
2-ubuntu-18-to-20-repositories.sh
· 342 B · Bash
Raw
sed -i 's/bionic/focal/g' /etc/apt/sources.listsed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
sed -i 's/ubuntu 18/ubuntu 20/g' /etc/apt/sources.list.d/zammad.list
apt clean; apt update
apt upgrade
apt dist-upgrade
pg_dropcluster --stop 13 main
pg_upgradecluster 11 main /var/lib/postgresql/13/
apt autoremove
shutdown -r now
1 | sed -i 's/bionic/focal/g' /etc/apt/sources.listsed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list |
2 | sed -i 's/ubuntu 18/ubuntu 20/g' /etc/apt/sources.list.d/zammad.list |
3 | apt clean; apt update |
4 | apt upgrade |
5 | apt dist-upgrade |
6 | |
7 | pg_dropcluster --stop 13 main |
8 | pg_upgradecluster 11 main /var/lib/postgresql/13/ |
9 | |
10 | apt autoremove |
11 | shutdown -r now |
3-debian-11-to-12-repositories.sh
· 442 B · Bash
Raw
sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list
sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list.d/pgdg.list
sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list
apt clean; apt update
apt upgrade
apt dist-upgrade
# Below two are no longer relevant if you use psql repo and already upgraded to psql 16
# pg_dropcluster --stop 13 main
# pg_upgradecluster 13 main /var/lib/postgresql/15/
apt autoremove
shutdown -r now
1 | sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list |
2 | sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list.d/pgdg.list |
3 | sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list |
4 | apt clean; apt update |
5 | apt upgrade |
6 | apt dist-upgrade |
7 | |
8 | # Below two are no longer relevant if you use psql repo and already upgraded to psql 16 |
9 | # pg_dropcluster --stop 13 main |
10 | # pg_upgradecluster 13 main /var/lib/postgresql/15/ |
11 | |
12 | apt autoremove |
13 | shutdown -r now |
3-ubuntu-20-to-22-repositories.sh
· 279 B · Bash
Raw
sed -i 's/focal/jammy/g' /etc/apt/sources.list
sed -i 's/ubuntu 20/ubuntu 22/g' /etc/apt/sources.list.d/zammad.list
apt clean; apt update
apt upgrade
apt dist-upgrade
pg_dropcluster --stop 13 main
pg_upgradecluster 13 main /var/lib/postgresql/15/
apt autoremove
shutdown -r now
1 | sed -i 's/focal/jammy/g' /etc/apt/sources.list |
2 | sed -i 's/ubuntu 20/ubuntu 22/g' /etc/apt/sources.list.d/zammad.list |
3 | apt clean; apt update |
4 | apt upgrade |
5 | apt dist-upgrade |
6 | |
7 | pg_dropcluster --stop 13 main |
8 | pg_upgradecluster 13 main /var/lib/postgresql/15/ |
9 | |
10 | apt autoremove |
11 | shutdown -r now |
4-finish-upgrade.sh
· 76 B · Bash
Raw
apt-mark unhold zammad
systemctl enable zammad
apt update
apt install zammad
1 | apt-mark unhold zammad |
2 | systemctl enable zammad |
3 | apt update |
4 | apt install zammad |