Re: Regarding the details of postgresql10 download - Mailing list pgsql-admin

From Ron
Subject Re: Regarding the details of postgresql10 download
Date
Msg-id 3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com
Whole thread Raw
In response to Re: Regarding the details of postgresql10 download  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-admin
On 11/15/23 09:57, Thomas Kellerer wrote:
Ramesh Penuballi schrieb am 14.11.2023 um 16:39:
We are using postgresql9.6 on our Atlassian Servers and planning to
perform the upgrades of our applications.

To migrate the applications to latest versions of our applications,as
per Atlassian applications supported versions,we have planned several
levels of our postgresql upgrades to support the different versions
of our Atlassian applications.

We are planning to upgrade postgres versions  from 9.6 to 10 in the
1st level, then from 10 to 12 in the 2nd level and then to 14.
Why upgrade in steps?

You can go directly from 9.6 to 14 (or 15 or 16) either using pg_upgrade
or through dump/restore

I don't see a need to install Postgres 10 (or 12) if you want to go to 14

Application software migrations can require multiple jumps like that.

Usually in those situations, though, it's really really old application/DB/OS combos.

--
Born in Arizona, moved to Babylonia.

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Regarding the details of postgresql10 download
Next
From: Edwin UY
Date:
Subject: Re: Upgrading/Updating Extensions