Message-ID: <83d29a1f-9da6-4f6f-a6be-97a7749a4fd3@cloud.gatewaynet.com>
Date: Sat, 9 Nov 2024 07:46:04 +0200
MIME-Version: 1.0
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
To: pgsql-general@lists.postgresql.org
References: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
 <E48C5CDC-9AF3-44DB-8FB7-79CD34AFD18D@thebuild.com>
Content-Language: en-US
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
In-Reply-To: <E48C5CDC-9AF3-44DB-8FB7-79CD34AFD18D@thebuild.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/83d29a1f-9da6-4f6f-a6be-97a7749a4fd3%40cloud.gatewaynet.com>
Precedence: bulk


Στις 8/11/24 20:16, ο/η Christophe Pettus έγραψε:
>
>> 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).

In which case I guess it is possible to use pg_upgrade of the maximum 
version in the same supported "window". e.g. pg_upgrade of 9.4 to 
upgrade from 8.3, and so forth, in iterations till someone hits the 
maximum desired version.

IMHO one should pay attention with pre-PGXS modules (such as intarray) , 
I stumped across some ugly situations with that.

>
> 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.
>