Re: Can we directly upgrade postgresql from 13 to 15.4

On 11/8/24 10:12, jayesh thakare wrote:
> Hi all,
>
> Can we upgrade postresql from 13 to 15.4 directly?
> Can we upgrade postgresql from 13 to 16 directly?

Yes either dump/restore:

https://www.postgresql.org/docs/current/app-pgdump.html

https://www.postgresql.org/docs/current/app-pgrestore.html

Or pg_upgrade:

https://www.postgresql.org/docs/current/pgupgrade.html

Pay particular attention to the Notes section at each of the above links

>
>
> Ideally how many major version can we jump to from older version ?
Some of that is covered in the Notes section.

You should also look at the Release Notes:

https://www.postgresql.org/docs/release/

The important ones are for Postgres version 10+ those for X.0 where X is
the major release e.g. 10, 11, 12, etc.

For 9- the release to look for is X.X.0 where X.X is 9.6, 9.5, 9.4, etc.

These will show you the major changes that you might need to deal with.
For example in Postgres 15 the langauges plpythonu/plpython2u where
removed, so if you are using plpython* functions you need to make sure
they have been migrated to plpython3u.

>
> Regards,
> Jayeshthakare
> 8828986182
> Postgresql dba | Clover Infotech

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com