Re: Upgrading postgres to 10 from 9.5 using pg_upgradecluster

From: Johannes Truschnigg <johannes(at)truschnigg(dot)info>
To: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading postgres to 10 from 9.5 using pg_upgradecluster
Date: 2017-11-11 11:26:35
Message-ID: 20171111112635.2cao3tmhgfvylahk@vault.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

On Sat, Nov 11, 2017 at 08:02:19AM +0530, Debraj Manna wrote:
> I am testing the process of upgrading postgres to 10 from 9.5
>
> [...]
>
> 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?

Before doing a release upgrade, we usually restore the latest backup of the
cluster that's going to be upgraded to another host, and perform the planned
upgrade procedure there. For the actual upgrade, we schedule a maintenance
window, and repeaet the steps recorded during the successful test-run. This
has the added benefit that you can have confidence in your recovery/restore
process in case something goes awry.

There's no other way I know of that "simulates" performing the actual upgrade
(pg_upgrade does some pre-flight checking before it actually starts doing
work, but errors can still arise after the point of no return - which in
"link" mode means that you'll have two broken clusters, and will have to
restore from backup).

> 2. If I am using the link option in the upgrade can I still use the sudo
> pg_dropcluster 9.5 main?

Yes.

It's a very good idea to gather experience with the workflow in a test setup,
just like you seem to be doing. You'll see that the procedure and tooling
around upgrades is very robust - but with database administration, nothing
beats a combination of diligent planning, carefulness, and experience.

--
with best regards:
- Johannes Truschnigg ( johannes(at)truschnigg(dot)info )

www: https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp: johannes(at)truschnigg(dot)info

Please do not bother me with HTML-email or attachments. Thank you.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tiago Kepe 2017-11-11 13:49:34 How to get detailed query execution statistics for each algebra operator or primitive
Previous Message Debraj Manna 2017-11-11 02:32:19 Upgrading postgres to 10 from 9.5 using pg_upgradecluster