User Tools
ubuntu_upgrade_pg
Differences
This shows you the differences between two versions of the page.
|
ubuntu_upgrade_pg [2019/01/14 22:40] ian |
ubuntu_upgrade_pg [2020/02/13 22:55] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | 1. Create a snapshot with XenServer | ||
| - | |||
| - | Stop the database to make sure snapshot is consistent. | ||
| - | < | ||
| - | # service postgresql stop | ||
| - | * Stopping PostgreSQL 9.3 database server | ||
| - | | ||
| - | </ | ||
| - | |||
| - | < | ||
| - | # xe vm-snapshot new-name-label=" | ||
| - | 26441bbe-9e47-5590-a93f-5b3cd2ddf9b7 | ||
| - | </ | ||
| - | |||
| - | 2. Install the PGDG repo | ||
| - | |||
| - | < | ||
| - | # sudo sh -c 'echo "deb http:// | ||
| - | |||
| - | # apt-get update | ||
| - | </ | ||
| - | |||
| - | 3. Install the PGDG postgresql upgrade | ||
| - | |||
| - | < | ||
| - | # apt install postgresql-9.4 | ||
| - | Reading package lists... Done | ||
| - | Building dependency tree | ||
| - | Reading state information... Done | ||
| - | The following extra packages will be installed: | ||
| - | postgresql-client-9.4 postgresql-contrib-9.4 | ||
| - | Suggested packages: | ||
| - | locales-all postgresql-doc-9.4 libdbd-pg-perl | ||
| - | The following NEW packages will be installed: | ||
| - | postgresql-9.4 postgresql-client-9.4 postgresql-contrib-9.4 | ||
| - | 0 upgraded, 3 newly installed, 0 to remove and 115 not upgraded. | ||
| - | Need to get 0 B/5,281 kB of archives. | ||
| - | After this operation, 24.8 MB of additional disk space will be used. | ||
| - | Do you want to continue? [Y/n] y | ||
| - | </ | ||
| - | |||
| - | 4. Remove the new PG server empty " | ||
| - | |||
| - | < | ||
| - | # pg_dropcluster --stop 9.4 main | ||
| - | </ | ||
| - | |||
| - | 5. Perform an upgrade which does a binary copy of the existing database | ||
| - | |||
| - | < | ||
| - | sudo -u postgres pg_dropcluster -v 9.4 9.3 main | ||
| - | Stopping old cluster... | ||
| - | Disabling connections to the old cluster during upgrade... | ||
| - | Restarting old cluster with restricted connections... | ||
| - | Creating new PostgreSQL cluster 9.4/main ... | ||
| - | </ | ||
| - | |||
| - | 6. Remove the old postgresql 9.3 (Ubuntu) packages | ||
| - | |||
| - | < | ||
| - | # apt-get remove postgresql\*-9.3 | ||
| - | </ | ||
| - | |||
| - | < | ||
| - | # apt-get autoremove | ||
| - | </ | ||
ubuntu_upgrade_pg.txt ยท 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
