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: | Raw Message | Whole Thread | 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 |