| From: | Debraj Manna <subharaj(dot)manna(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Upgrading postgres to 10 from 9.5 using pg_upgradecluster |
| Date: | 2017-11-11 02:32:19 |
| Message-ID: | CAF6DVKPJtqap_i=CZOR0aE794CoJvoH=ZzmPUSYQWWOQ8hXs0Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am testing the process of upgrading postgres to 10 from 9.5
I am following the steps as mentioned in this link
<https://gist.github.com/dmitrykustov/27c673ec4f7abd716912e4c830910019> -
dmanna(at)ubuntu:~$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log
file9.5 main 5432 online postgres /var/lib/postgresql/9.5/main
/var/log/postgresql/postgresql-9.5-main.log10 main 5433 online
postgres /var/lib/postgresql/10/main
/var/log/postgresql/postgresql-10-main.log
sudo pg_dropcluster 10 main --stop
sudo pg_upgradecluster 9.5 main -m upgrade
sudo pg_dropcluster 9.5 main
Can someone let me know the following
1. If there is a way I can check if the upgrade will be successful
before going for the actual upgrade?
2. If I am using the link option in the upgrade can I still use the sudo
pg_dropcluster 9.5 main?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Johannes Truschnigg | 2017-11-11 11:26:35 | Re: Upgrading postgres to 10 from 9.5 using pg_upgradecluster |
| Previous Message | Dale,Bob | 2017-11-10 20:02:30 | pgaudit/Password Redaction |