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 1723306495. Go to revision

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

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

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

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

No changes

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

No changes

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

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

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

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

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

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