pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Regarding the details of postgresql10 download
Date: Wed, 15 Nov 2023 10:14:55 -0600
Message-ID: <3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com> (raw)
In-Reply-To: <61b029c3-f03f-4d2c-aef7-6949ee23f945@gmx.net>
References: <CAGeQtUvm7RGvxJjHXcrGibM09uTG9sT_XQXUBzOrCRKtTKYcVQ@mail.gmail.com>
	<61b029c3-f03f-4d2c-aef7-6949ee23f945@gmx.net>

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.

view thread (5+ messages)

Message-ID: <3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com>
Permalink:  ../3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com/
Also on:    postgresql.org/message-id/3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Regarding the details of postgresql10 download
  In-Reply-To: <3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox