public inbox for [email protected]  
help / color / mirror / Atom feed
From: Adrian Klaver <[email protected]>
To: Jaya Sandeep <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster
Date: Fri, 17 Apr 2026 07:08:21 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEgpDvFGsBLdmbbWYJK537wj6nNmRu3vKSWkgjJ-ZU0qmGu07Q@mail.gmail.com>
References: <CAEgpDvG76VG4YVq8SayUb+tV2NsB+BfHxE=zBSu+9bxXiChi7Q@mail.gmail.com>
	<CANzqJaDyzoTMxmaApLd2xYmKg5Bgs_wYcOLbVhsink-0OO183A@mail.gmail.com>
	<CAEgpDvFGsBLdmbbWYJK537wj6nNmRu3vKSWkgjJ-ZU0qmGu07Q@mail.gmail.com>

On 4/17/26 6:20 AM, Jaya Sandeep wrote:
>   Upgrading to  16 version,  guidance on this .

Ron's point is that you are currently at Postgres 14.6 and there are 
approximately 4 years of bug fixes to the current stable 14.22 version 
as seen here:

https://www.postgresql.org/docs/14/release.html

It would be good idea to bring the 14 instance to as an up to date state 
as possible before moving on to latest major version(18), which in 
itself is a jump of 4 major versions.

As to the major to major upgrade I would suggest reading:

https://clusterlabs.org/projects/pacemaker/doc/3.0/Pacemaker_Administration/html/

and

https://www.postgresql.org/docs/18/pgupgrade.html



> 
> Thank you.
> 
> Regards,
> Neelam Jaya Sandeep
> 9492727845
> 
> On Fri, 17 Apr, 2026, 18:43 Ron Johnson, <[email protected] 
> <mailto:[email protected]>> wrote:
> 
>     On Fri, Apr 17, 2026 at 1:55 AM Jaya Sandeep
>     <[email protected] <mailto:[email protected]>> wrote:
>     [snip]
> 
>         *Details :*
>         Current version of PostgreSQL is *14.6 *
> 
> 
>     Step #1 is to update to fix the 3.5 years of bugs from 14.6 to
>     14.22.  Each node update should take no more than 5 minutes.
> 
>     -- 
>     Death to <Redacted>, and butter sauce.
>     Don't boil me, I'm still alive.
>     <Redacted> lobster!
> 


-- 
Adrian Klaver
[email protected]






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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster
  In-Reply-To: <[email protected]>

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

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