> On Nov 8, 2024, at 10:12, jayesh thakare <thakarejayesh700(at)gmail(dot)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.