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 22:20] 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 7: | Line 10: | ||
| | ||
</ | </ | ||
+ | postgresql | ||
< | < | ||
- | # xe vm-snapshot new-name-label=" | + | xenserver# xe vm-snapshot new-name-label=" |
26441bbe-9e47-5590-a93f-5b3cd2ddf9b7 | 26441bbe-9e47-5590-a93f-5b3cd2ddf9b7 | ||
</ | </ | ||
- | 2. Remove | + | 2. Install |
< | < | ||
- | # apt-get remove | + | # sudo sh -c 'echo "deb http://apt.postgresql.org/ |
+ | |||
+ | # curl https:// | ||
+ | |||
+ | # apt-get update | ||
</ | </ | ||
+ | |||
+ | 3. Install the PGDG postgresql upgrade | ||
< | < | ||
- | # apt-get autoremove | + | # aptitude install postgresql-9.4 |
+ | The following NEW packages will be installed: | ||
+ | postgresql-9.4 postgresql-client-9.4{a} postgresql-contrib-9.4{a} | ||
+ | 0 packages upgraded, 3 newly installed, 0 to remove and 115 not upgraded. | ||
+ | Need to get 0 B/5,281 kB of archiv | ||
</ | </ | ||
- | 3. Install | + | 4. Remove |
< | < | ||
- | # sudo sh -c 'echo "deb http:// | + | # sudo -u postgres pg_dropcluster |
+ | </code> | ||
- | # apt-get update | + | 5. Perform an upgrade which does a binary copy of the existing database |
+ | |||
+ | < | ||
+ | # service postgresql stop | ||
+ | |||
+ | # pg_upgradecluster -v 9.4 9.3 main | ||
+ | Disabling connections to the old cluster during upgrade... | ||
+ | Restarting old cluster with restricted connections... | ||
+ | Creating new cluster 9.4/main ... | ||
+ | config / | ||
+ | data / | ||
+ | locale en_CA.UTF-8 | ||
+ | port | ||
+ | Disabling connections to the new cluster during upgrade... | ||
+ | ... | ||
+ | Success. Please check that the upgraded cluster works. If it does, | ||
+ | you can remove the old cluster with | ||
+ | |||
+ | pg_dropcluster 9.3 main | ||
</ | </ | ||
- | 4. Install | + | 6. Remove |
< | < | ||
- | # aptitude install postgresql-9.4 | + | # apt-get remove |
- | The following NEW packages will be installed: | + | |
- | | + | |
- | 0 packages upgraded, 5 newly installed, 0 to remove and 111 not upgraded. | + | |
- | Need to get 0 B/5,588 kB of archives. After unpacking 25.5 MB will be used. | + | |
- | Do you want to continue? [Y/n/?] y | + | |
</ | </ | ||
- | 5. Remove | + | < |
+ | # apt-get autoremove | ||
+ | </ | ||
+ | |||
+ | 7. Proceed with the Ubuntu upgrade | ||
< | < | ||
- | # sudo -u postgres pg_dropcluster 9.4 main | + | # apt-get dist-upgrade |
+ | |||
+ | # do-release-upgrade | ||
</ | </ | ||
- | 6. Perform an upgrade which does a binary copy of the existing database | + | And restore |
< | < | ||
- | # sudo -u postgres pg_upgradecluster -v 9.4 9.3 main | + | # sudo sh -c 'echo "deb http://apt.postgresql.org/ |
- | Stopping old cluster... | + | |
- | Disabling connections to the old cluster during upgrade... | + | # apt update |
- | Restarting old cluster with restricted connections... | + | |
- | Creating new PostgreSQL cluster 9.4/main ... | + | # apt full-upgrade |
</ | </ | ||
+ | |||