This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
ubuntu_upgrade_pg [2019/01/26 13:18] ian |
ubuntu_upgrade_pg [2020/02/13 22:55] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Upgrade of PostgreSQL and Ubuntu upgrade ====== | ||
+ | |||
+ | |||
1. Create a snapshot with XenServer | 1. Create a snapshot with XenServer | ||
Line 36: | Line 39: | ||
< | < | ||
- | # sudo -u postgres pg_dropcluster 9.4 main | + | # sudo -u postgres pg_dropcluster |
</ | </ | ||
Line 42: | Line 45: | ||
< | < | ||
+ | # service postgresql stop | ||
+ | |||
# pg_upgradecluster -v 9.4 9.3 main | # pg_upgradecluster -v 9.4 9.3 main | ||
Disabling connections to the old cluster during upgrade... | Disabling connections to the old cluster during upgrade... | ||
Line 61: | Line 66: | ||
< | < | ||
- | # apt-get remove postgresql postgresql\*-9.3 | + | # apt-get remove postgresql postgresql.*-9.3 |
</ | </ | ||
Line 72: | Line 77: | ||
< | < | ||
# apt-get dist-upgrade | # apt-get dist-upgrade | ||
- | |||
- | # apt-mark hold bacula-fd | ||
# do-release-upgrade | # do-release-upgrade | ||
Line 81: | Line 84: | ||
< | < | ||
- | sudo sh -c 'echo "deb http:// | + | # sudo sh -c 'echo "deb http:// |
+ | |||
+ | # apt update | ||
+ | |||
+ | # apt full-upgrade | ||
</ | </ | ||