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

MrGeneration's Avatar MrGeneration revised this gist 1708102550. Go to revision

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's Avatar MrGeneration revised this gist 1708101552. Go to revision

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's Avatar MrGeneration revised this gist 1708101269. Go to revision

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's Avatar MrGeneration revised this gist 1708100922. Go to revision

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's Avatar MrGeneration revised this gist 1707951033. Go to revision

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's Avatar MrGeneration revised this gist 1706727055. Go to revision

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's Avatar MrGeneration revised this gist 1706664602. Go to revision

1 file changed, 0 insertions, 0 deletions

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

File renamed without changes

MrGeneration's Avatar MrGeneration revised this gist 1706664582. Go to revision

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
Newer Older