Login Register
MrGeneration

MrGeneration / Debian / Ubuntu Upgrade

Last active 4 months ago

Like 0

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

MrGeneration revised this gist 2 years ago · d08cb69

1 file changed, 1 insertion, 1 deletion

3-debian-11-to-12-repositories.sh
@@ -4,7 +4,7 @@ apt clean; apt update
4 4 apt upgrade
5 5 apt dist-upgrade
6 6
7 - pg_dropcluster --stop 13 main
7 + pg_dropcluster --stop 15 main
8 8 pg_upgradecluster 13 main /var/lib/postgresql/15/
9 9
10 10 apt autoremove

MrGeneration revised this gist 2 years ago · e3f7e8e

1 file changed, 1 insertion, 1 deletion

3-ubuntu-20-to-22-repositories.sh
@@ -4,7 +4,7 @@ apt clean; apt update
4 4 apt upgrade
5 5 apt dist-upgrade
6 6
7 - pg_dropcluster --stop 13 main
7 + pg_dropcluster --stop 15 main
8 8 pg_upgradecluster 13 main /var/lib/postgresql/15/
9 9
10 10 apt autoremove

MrGeneration revised this gist 2 years ago · 21ed933

1 file changed, 2 insertions, 1 deletion

3-debian-11-to-12-repositories.sh
@@ -1,5 +1,6 @@
1 1 sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list
2 - sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.listapt clean; apt update
2 + sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list
3 + apt clean; apt update
3 4 apt upgrade
4 5 apt dist-upgrade
5 6

MrGeneration revised this gist 2 years ago · 2e7e530

2 files changed, 1 insertion, 5 deletions

2-debian-10-to-11-repositories.sh
@@ -1,8 +1,6 @@
1 1 sed -i 's/debian-security buster\/updates/ bullseye-security/g' /etc/apt/sources.list
2 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 3 sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list
5 -
6 4 apt clean; apt update
7 5 apt upgrade
8 6 apt dist-upgrade
3-debian-11-to-12-repositories.sh
@@ -1,7 +1,5 @@
1 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
2 + sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.listapt clean; apt update
5 3 apt upgrade
6 4 apt dist-upgrade
7 5

MrGeneration revised this gist 2 years ago · 38dee94

3 files changed, 4 insertions, 16 deletions

1-general-prerequisites-before-upgrade.sh
@@ -3,10 +3,4 @@ apt-mark hold zammad
3 3 apt update
4 4 apt upgrade
5 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 6 # Continue with step 2 or 3 depending on your current state
2-debian-10-to-11-repositories.sh
@@ -7,13 +7,8 @@ apt clean; apt update
7 7 apt upgrade
8 8 apt dist-upgrade
9 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/
10 + pg_dropcluster --stop 13 main
11 + pg_upgradecluster 11 main /var/lib/postgresql/13/
17 12
18 13 apt autoremove
19 14 shutdown -r now
3-debian-11-to-12-repositories.sh
@@ -5,9 +5,8 @@ apt clean; apt update
5 5 apt upgrade
6 6 apt dist-upgrade
7 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/
8 + pg_dropcluster --stop 13 main
9 + pg_upgradecluster 13 main /var/lib/postgresql/15/
11 10
12 11 apt autoremove
13 12 shutdown -r now

MrGeneration revised this gist 2 years ago · 1346b19

1 file changed, 1 insertion, 1 deletion

2-debian-10-to-11-repositories.sh
@@ -1,4 +1,4 @@
1 - sed -i 's/debian-security buster\/updates/ bookworm-security/g' /etc/apt/sources.list
1 + sed -i 's/debian-security buster\/updates/ bullseye-security/g' /etc/apt/sources.list
2 2 sed -i 's/buster/bullseye/g' /etc/apt/sources.list
3 3 sed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
4 4 sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list

MrGeneration revised this gist 2 years ago · 82ffc23

4 files changed, 20 insertions, 5 deletions

1-general-prerequisites-before-upgrade.sh
@@ -3,4 +3,10 @@ apt-mark hold zammad
3 3 apt update
4 4 apt upgrade
5 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 +
6 12 # Continue with step 2 or 3 depending on your current state
2-debian-10-to-11-repositories.sh
@@ -1,12 +1,19 @@
1 1 sed -i 's/debian-security buster\/updates/ bookworm-security/g' /etc/apt/sources.list
2 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
3 4 sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list
5 +
4 6 apt clean; apt update
5 7 apt upgrade
6 8 apt dist-upgrade
7 9
8 - pg_dropcluster --stop 13 main
9 - pg_upgradecluster 11 main /var/lib/postgresql/13/
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/
10 17
11 18 apt autoremove
12 19 shutdown -r now
2-ubuntu-18-to-20-repositories.sh
@@ -1,4 +1,4 @@
1 - sed -i 's/bionic/focal/g' /etc/apt/sources.list
1 + sed -i 's/bionic/focal/g' /etc/apt/sources.listsed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
2 2 sed -i 's/ubuntu 18/ubuntu 20/g' /etc/apt/sources.list.d/zammad.list
3 3 apt clean; apt update
4 4 apt upgrade
3-debian-11-to-12-repositories.sh
@@ -1,11 +1,13 @@
1 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
2 3 sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list
3 4 apt clean; apt update
4 5 apt upgrade
5 6 apt dist-upgrade
6 7
7 - pg_dropcluster --stop 13 main
8 - pg_upgradecluster 13 main /var/lib/postgresql/15/
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/
9 11
10 12 apt autoremove
11 13 shutdown -r now

MrGeneration revised this gist 2 years ago · 12092a2

5 files changed, 4 insertions, 4 deletions

2-debian-10-to-11-repositories.sh
@@ -1,5 +1,6 @@
1 1 sed -i 's/debian-security buster\/updates/ bookworm-security/g' /etc/apt/sources.list
2 2 sed -i 's/buster/bullseye/g' /etc/apt/sources.list
3 + sed -i 's/debian 10/debian 11/g' /etc/apt/sources.list.d/zammad.list
3 4 apt clean; apt update
4 5 apt upgrade
5 6 apt dist-upgrade
2-ubuntu-18-to-20-repositories.sh
@@ -1,4 +1,5 @@
1 1 sed -i 's/bionic/focal/g' /etc/apt/sources.list
2 + sed -i 's/ubuntu 18/ubuntu 20/g' /etc/apt/sources.list.d/zammad.list
2 3 apt clean; apt update
3 4 apt upgrade
4 5 apt dist-upgrade
3-debian-11-to-12-repositories.sh
@@ -1,4 +1,5 @@
1 1 sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list
2 + sed -i 's/debian 11/debian 12/g' /etc/apt/sources.list.d/zammad.list
2 3 apt clean; apt update
3 4 apt upgrade
4 5 apt dist-upgrade
3-ubuntu-20-to-22-repositories.sh
@@ -1,4 +1,5 @@
1 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
2 3 apt clean; apt update
3 4 apt upgrade
4 5 apt dist-upgrade
4-finish-upgrade.sh
@@ -1,8 +1,4 @@
1 1 apt-mark unhold zammad
2 -
3 - # ADJUST /etc/apt/sources.list.d/zammad.list WITH YOUR OS-VERSION-NUMBER
4 - # (bullseye: 11; bookworm: 12; focal: 20; jammy: 22)
5 -
6 2 systemctl enable zammad
7 3 apt update
8 4 apt install zammad

MrGeneration revised this gist 2 years ago · 98dd1f5

1 file changed

4-finish-upgrade renamed to 4-finish-upgrade.sh

File renamed without changes

MrGeneration revised this gist 2 years ago · 2a31e36

6 files changed, 55 insertions

1-general-prerequisites-before-upgrade.sh (file created)
@@ -0,0 +1,6 @@
1 + systemctl disable zammad --now
2 + apt-mark hold zammad
3 + apt update
4 + apt upgrade
5 +
6 + # Continue with step 2 or 3 depending on your current state
2-debian-10-to-11-repositories.sh (file created)
@@ -0,0 +1,11 @@
1 + sed -i 's/debian-security buster\/updates/ bookworm-security/g' /etc/apt/sources.list
2 + sed -i 's/buster/bullseye/g' /etc/apt/sources.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
2-ubuntu-18-to-20-repositories.sh (file created)
@@ -0,0 +1,10 @@
1 + sed -i 's/bionic/focal/g' /etc/apt/sources.list
2 + apt clean; apt update
3 + apt upgrade
4 + apt dist-upgrade
5 +
6 + pg_dropcluster --stop 13 main
7 + pg_upgradecluster 11 main /var/lib/postgresql/13/
8 +
9 + apt autoremove
10 + shutdown -r now
3-debian-11-to-12-repositories.sh (file created)
@@ -0,0 +1,10 @@
1 + sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list
2 + apt clean; apt update
3 + apt upgrade
4 + apt dist-upgrade
5 +
6 + pg_dropcluster --stop 13 main
7 + pg_upgradecluster 13 main /var/lib/postgresql/15/
8 +
9 + apt autoremove
10 + shutdown -r now
3-ubuntu-20-to-22-repositories.sh (file created)
@@ -0,0 +1,10 @@
1 + sed -i 's/focal/jammy/g' /etc/apt/sources.list
2 + apt clean; apt update
3 + apt upgrade
4 + apt dist-upgrade
5 +
6 + pg_dropcluster --stop 13 main
7 + pg_upgradecluster 13 main /var/lib/postgresql/15/
8 +
9 + apt autoremove
10 + shutdown -r now
4-finish-upgrade (file created)
@@ -0,0 +1,8 @@
1 + apt-mark unhold zammad
2 +
3 + # ADJUST /etc/apt/sources.list.d/zammad.list WITH YOUR OS-VERSION-NUMBER
4 + # (bullseye: 11; bookworm: 12; focal: 20; jammy: 22)
5 +
6 + systemctl enable zammad
7 + apt update
8 + apt install zammad