> 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
planchanges or other surprises. It's essential to test your application thoroughly on the target version, and do dry
runsof pg_upgrade.