| @@ -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 | |
MrGeneration / Debian / Ubuntu Upgrade
Last active 4 months ago
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
| @@ -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 | |
| @@ -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 | |
| @@ -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 | |
| @@ -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 | |
| @@ -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
| @@ -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 | |
File renamed without changes
MrGeneration
revised this gist 2 years ago
·
84d671a
1 file changed, 1 insertion
| @@ -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
| @@ -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
| @@ -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 | |
| @@ -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 | |
| @@ -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 | |
| @@ -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 | |
| @@ -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 | |
| @@ -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
| @@ -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
| @@ -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
| @@ -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 | |
| @@ -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 | |