User Tools
ubuntu_upgrade_pg
Differences
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/14 23:00] 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 17: | Line 20: | ||
| < | < | ||
| # sudo sh -c 'echo "deb http:// | # sudo sh -c 'echo "deb http:// | ||
| + | |||
| + | # curl https:// | ||
| # apt-get update | # apt-get update | ||
| Line 34: | Line 39: | ||
| < | < | ||
| - | # sudo -u postgres pg_dropcluster 9.4 main | + | # sudo -u postgres pg_dropcluster |
| </ | </ | ||
| Line 40: | 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 59: | Line 66: | ||
| < | < | ||
| - | # apt-get remove postgresql postgresql\*-9.3 | + | # apt-get remove postgresql postgresql.*-9.3 |
| </ | </ | ||
| Line 69: | Line 76: | ||
| < | < | ||
| + | # apt-get dist-upgrade | ||
| + | |||
| # do-release-upgrade | # do-release-upgrade | ||
| </ | </ | ||
| Line 75: | Line 84: | ||
| < | < | ||
| - | sudo sh -c 'echo "deb http:// | + | # sudo sh -c 'echo "deb http:// |
| + | |||
| + | # apt update | ||
| + | |||
| + | # apt full-upgrade | ||
| </ | </ | ||
ubuntu_upgrade_pg.1547524816.txt.gz · Last modified: 2020/02/13 22:55 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
