Re: upgrade postgres 9.5 to 9.6

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: upgrade postgres 9.5 to 9.6
Date: 2021-01-15 15:17:28
Message-ID: aab15b25-19ba-8a07-8d47-272d10e7f7b5@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Atul Kumar schrieb am 15.01.2021 um 14:17:
> I want to upgrade my server from postgres 9.5 to 9.6, but my DB size
> is in TBs and I want to do it in minimum downtime (2-3 hours) so
> please help me how should I perform it.
>
>
> Please share the document, if possible, it will be grateful.

pg_upgrade with the --link option should only take a few minutes.

Is there a reason you are upgrading to 9.6 and not 12 or 13?

9.6 will be end-of-live this November (in 10 months), you will have to do another upgrade then.

Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Stoddard 2021-01-15 15:19:45 Accounting for between table correlation
Previous Message Kristi Kangas 2021-01-15 14:35:27 PostgreSQL License Question