Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3IXg-002zvw-3e for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2023 16:15:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r3IXd-000ZK3-Bu for pgsql-admin@arkaria.postgresql.org; Wed, 15 Nov 2023 16:15:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r3IXc-000ZIf-TF for pgsql-admin@lists.postgresql.org; Wed, 15 Nov 2023 16:15:00 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r3IXa-006aRF-FY for pgsql-admin@lists.postgresql.org; Wed, 15 Nov 2023 16:15:00 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-dafe04717baso2718917276.1 for ; Wed, 15 Nov 2023 08:14:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1700064896; x=1700669696; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=cy0iy8ky4NYX1iq3bS5bjNFKL560OpdmexUkkE1XD0Y=; b=l3LYwjxadJc1RDvhIDdcYES5mIAgJisbacSUQr1ugs/sViVy2pa0FnEkZVQc3d30BP HycoD4Rg1mv43e+/+pX/tK9wC8bEOSHCpckSAgML4Ie7cRhru3UDZubRouMB63Yn0GfJ iVj+oydyIPTC139xcon63XbmmfGHQcQbhaLl7TeM3D6M6xBrNaCTOWNBe1AQwpAjHxJj nmeAIzpBCLuNWWBjj4iujY2VibmFnq6fYN3PqxtnW6odn+9+wrjOhkttdnnSXczTkL6m jBIt3Cz+snXQrH1puOva7LpDx2LqNuusbVKYlWpyTKaE4afcOZQFPC59NVmLDAmpxrlq rPaA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1700064896; x=1700669696; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=cy0iy8ky4NYX1iq3bS5bjNFKL560OpdmexUkkE1XD0Y=; b=tEtcRGkA/hq4KkoZI9AD5Bw9eyBzfWOtcbqjha/SecBAklOGP4rsT1dxY+Or++00uX 3Nr9jryvHb1SQML4tqFh9pwqulWLZ0ROmZ3h8WYRrjBAwq42XortVewQr5otXGTw6yCb F93GKSVectfnDKZahXYqBlhPofn50TOJCAUsw0s+hSc4nZoo0oSHZpwTmylCW/5E4Qop G1kbFqRlb4xbaBrEUEURh+L/soMKkDaHYV+lo3enqyv001iT8SRjD0ebqHM3v2Y5XI9F vfAAl3kSd5XlNhAEWFt43+4cIJ+87T0AwbN0yhkaqVh7OuRrfJGbGoG1N6M0ukGYcY2E 2hIA== X-Gm-Message-State: AOJu0YyuXPaxFEvnfvV7e5GZBU2X3vPskrkNXMPJozZbmqk1yRZfNvxV oOUC+jM5aWG3oIRmi+vWmfhBZ9bWrKo= X-Google-Smtp-Source: AGHT+IGeIUTc6cRtMltCXmAoNlIljEzQPr16mvMrN4aTc3jlCrmHW6nM/VJtcSnOaJKssDYSHFiKLA== X-Received: by 2002:a25:b094:0:b0:d9c:7b92:90b9 with SMTP id f20-20020a25b094000000b00d9c7b9290b9mr11296633ybj.14.1700064896166; Wed, 15 Nov 2023 08:14:56 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id e3-20020a25e703000000b00da041da21e7sm393460ybh.65.2023.11.15.08.14.55 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 15 Nov 2023 08:14:55 -0800 (PST) Content-Type: multipart/alternative; boundary="------------1yRB8gG5SQOHtTthiqxSgn3M" Message-ID: <3beddfcb-a39f-4791-808b-e45aa017e6d9@gmail.com> Date: Wed, 15 Nov 2023 10:14:55 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Regarding the details of postgresql10 download Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <61b029c3-f03f-4d2c-aef7-6949ee23f945@gmx.net> From: Ron In-Reply-To: <61b029c3-f03f-4d2c-aef7-6949ee23f945@gmx.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------1yRB8gG5SQOHtTthiqxSgn3M Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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. --------------1yRB8gG5SQOHtTthiqxSgn3M Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit 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.
--------------1yRB8gG5SQOHtTthiqxSgn3M--