Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
Date: Fri, 8 Nov 2024 10:16:39 -0800
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <E48C5CDC-9AF3-44DB-8FB7-79CD34AFD18D@thebuild.com>
References: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
To: jayesh thakare <thakarejayesh700@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/E48C5CDC-9AF3-44DB-8FB7-79CD34AFD18D%40thebuild.com>
Precedence: bulk


> On Nov 8, 2024, at 10:12, jayesh thakare <thakarejayesh700@gmail.com> =
wrote:
> Can we upgrade postresql from 13 to 15.4 directly?
> Can we upgrade postgresql from 13 to 16 directly?

Yes.

> Ideally how many major version can we jump to from older version ?

There's no practical limit, assuming the old version is not an ancient =
version of PostgreSQL (pre-9.0, say).

That being said, PostgreSQL's behavior changes with every major release, =
and there is always the possibility of query plan changes or other =
surprises.  It's essential to test your application thoroughly on the =
target version, and do dry runs of pg_upgrade.=