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 1 year ago · be210cd

6 files changed, 11 insertions, 6 deletions

2-debian-10-to-11-repositories.sh
@@ -7,7 +7,8 @@ apt upgrade
7 7 apt dist-upgrade
8 8
9 9 pg_dropcluster --stop 13 main
10 - pg_upgradecluster 11 main /var/lib/postgresql/13/
10 + pg_upgradecluster 11 main /var/lib/postgresql/13/main/
11 11
12 12 apt autoremove
13 + apt purge postgresql-11 postgresql-client-11
13 14 shutdown -r now
2-ubuntu-18-to-20-repositories.sh
@@ -5,7 +5,8 @@ apt upgrade
5 5 apt dist-upgrade
6 6
7 7 pg_dropcluster --stop 12 main
8 - pg_upgradecluster 10 main /var/lib/postgresql/12/
8 + pg_upgradecluster 10 main /var/lib/postgresql/12/main/
9 9
10 10 apt autoremove
11 + apt purge postgresql-10 postgresql-client-10
11 12 shutdown -r now
3-debian-11-to-12-repositories.sh
@@ -5,7 +5,8 @@ apt upgrade
5 5 apt dist-upgrade
6 6
7 7 pg_dropcluster --stop 15 main
8 - pg_upgradecluster 13 main /var/lib/postgresql/15/
8 + pg_upgradecluster 13 main /var/lib/postgresql/15/main/
9 9
10 10 apt autoremove
11 + apt purge postgresql-13 postgresql-client-13
11 12 shutdown -r now
3-ubuntu-20-to-22-repositories.sh
@@ -5,7 +5,8 @@ apt upgrade
5 5 apt dist-upgrade
6 6
7 7 pg_dropcluster --stop 14 main
8 - pg_upgradecluster 12 main /var/lib/postgresql/14/
8 + pg_upgradecluster 12 main /var/lib/postgresql/14/main/
9 9
10 10 apt autoremove
11 + apt purge postgresql-12 postgresql-client-12
11 12 shutdown -r now
4-ubuntu-22-to-24-repositories.sh
@@ -5,7 +5,8 @@ apt upgrade
5 5 apt dist-upgrade
6 6
7 7 pg_dropcluster --stop 16 main
8 - pg_upgradecluster 14 main /var/lib/postgresql/16/
8 + pg_upgradecluster 14 main /var/lib/postgresql/16/main/
9 9
10 10 apt autoremove
11 + apt purge postgresql-14 postgresql-client-14
11 12 shutdown -r now
pro-tip-huge-instance.sh
@@ -1,4 +1,4 @@
1 1 # The following action is NOT reversible but is significantly faster.
2 2 # Use at own descression - replace oldversion with your old version and newversion with your new version
3 3
4 - pg_upgradecluster --method=upgrade --link <oldversion> main /var/lib/postgresql/<newversion>/
4 + pg_upgradecluster --method=upgrade --link <oldversion> main /var/lib/postgresql/<newversion>/main/

MrGeneration revised this gist 2 years ago · 0f68534

2 files changed, 11 insertions

4-ubuntu-22-to-24-repositories.sh (file created)
@@ -0,0 +1,11 @@
1 + sed -i 's/jammy/noble/g' /etc/apt/sources.list
2 + sed -i 's/ubuntu 22/ubuntu 24/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 16 main
8 + pg_upgradecluster 14 main /var/lib/postgresql/16/
9 +
10 + apt autoremove
11 + shutdown -r now
4-finish-upgrade.sh renamed to 5-finish-upgrade.sh

File renamed without changes

MrGeneration revised this gist 2 years ago · 84d671a

1 file changed, 1 insertion

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

MrGeneration revised this gist 2 years ago · f5dc4fa

1 file changed, 4 insertions

pro-tip-huge-instance.sh (file created)
@@ -0,0 +1,4 @@
1 + # The following action is NOT reversible but is significantly faster.
2 + # Use at own descression - replace oldversion with your old version and newversion with your new version
3 +
4 + pg_upgradecluster --method=upgrade --link <oldversion> main /var/lib/postgresql/<newversion>/

MrGeneration revised this gist 2 years ago · efd45f7

6 files changed, 6 insertions, 6 deletions

1-general-prerequisites-before-upgrade.sh
@@ -3,4 +3,4 @@ apt-mark hold zammad
3 3 apt update
4 4 apt upgrade
5 5
6 - # Continue with step 2 or 3 depending on your current state
6 + # Continue with step 2 or 3 depending on your current state
2-debian-10-to-11-repositories.sh
@@ -9,4 +9,4 @@ pg_dropcluster --stop 13 main
9 9 pg_upgradecluster 11 main /var/lib/postgresql/13/
10 10
11 11 apt autoremove
12 - shutdown -r now
12 + shutdown -r now
2-ubuntu-18-to-20-repositories.sh
@@ -8,4 +8,4 @@ pg_dropcluster --stop 12 main
8 8 pg_upgradecluster 10 main /var/lib/postgresql/12/
9 9
10 10 apt autoremove
11 - shutdown -r now
11 + shutdown -r now
3-debian-11-to-12-repositories.sh
@@ -8,4 +8,4 @@ pg_dropcluster --stop 15 main
8 8 pg_upgradecluster 13 main /var/lib/postgresql/15/
9 9
10 10 apt autoremove
11 - shutdown -r now
11 + shutdown -r now
3-ubuntu-20-to-22-repositories.sh
@@ -8,4 +8,4 @@ pg_dropcluster --stop 14 main
8 8 pg_upgradecluster 12 main /var/lib/postgresql/14/
9 9
10 10 apt autoremove
11 - shutdown -r now
11 + shutdown -r now
4-finish-upgrade.sh
@@ -1,4 +1,4 @@
1 1 apt-mark unhold zammad
2 2 systemctl enable zammad
3 3 apt update
4 - apt install zammad
4 + apt install zammad

MrGeneration revised this gist 2 years ago · 322970e

1 file changed, 2 insertions, 2 deletions

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

MrGeneration revised this gist 2 years ago · 99743e4

No changes

MrGeneration revised this gist 2 years ago · f6b595e

No changes

MrGeneration revised this gist 2 years ago · 1760d65

1 file changed, 2 insertions, 2 deletions

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

MrGeneration revised this gist 2 years ago · 13ce2ae

2 files changed, 5 insertions, 5 deletions

2-ubuntu-18-to-20-repositories.sh
@@ -1,11 +1,11 @@
1 - sed -i 's/bionic/focal/g' /etc/apt/sources.listsed -i 's/buster/bullseye/g' /etc/apt/sources.list.d/pgdg.list
1 + sed -i 's/bionic/focal/g' /etc/apt/sources.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
5 5 apt dist-upgrade
6 6
7 - pg_dropcluster --stop 13 main
8 - pg_upgradecluster 11 main /var/lib/postgresql/13/
7 + pg_dropcluster --stop 12 main
8 + pg_upgradecluster 10 main /var/lib/postgresql/12/
9 9
10 10 apt autoremove
11 11 shutdown -r now
3-ubuntu-20-to-22-repositories.sh
@@ -4,8 +4,8 @@ apt clean; apt update
4 4 apt upgrade
5 5 apt dist-upgrade
6 6
7 - pg_dropcluster --stop 15 main
8 - pg_upgradecluster 13 main /var/lib/postgresql/15/
7 + pg_dropcluster --stop 14 main
8 + pg_upgradecluster 12 main /var/lib/postgresql/14/
9 9
10 10 apt autoremove
11 11 shutdown -r now