public inbox for [email protected]  

help / color / mirror / Atom feed

From: Achilleas Mantzios <[email protected]>
To: [email protected]
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
Date: Sat, 9 Nov 2024 07:46:04 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
	<[email protected]>


Στις 8/11/24 20:16, ο/η Christophe Pettus έγραψε:
>
>> On Nov 8, 2024, at 10:12, jayesh thakare <[email protected]> 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.
>

view thread (4+ messages)

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]
  Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
  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