public inbox for [email protected]help / color / mirror / Atom feed
Can we directly upgrade postgresql from 13 to 15.4 4+ messages / 4 participants [nested] [flat]
* Can we directly upgrade postgresql from 13 to 15.4 @ 2024-11-08 18:12 jayesh thakare <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: jayesh thakare @ 2024-11-08 18:12 UTC (permalink / raw) To: [email protected] Hi all, Can we upgrade postresql from 13 to 15.4 directly? Can we upgrade postgresql from 13 to 16 directly? Ideally how many major version can we jump to from older version ? Regards, Jayeshthakare 8828986182 Postgresql dba | Clover Infotech ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can we directly upgrade postgresql from 13 to 15.4 @ 2024-11-08 18:16 Christophe Pettus <[email protected]> parent: jayesh thakare <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Christophe Pettus @ 2024-11-08 18:16 UTC (permalink / raw) To: jayesh thakare <[email protected]>; +Cc: [email protected] > 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). 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can we directly upgrade postgresql from 13 to 15.4 @ 2024-11-08 20:23 Adrian Klaver <[email protected]> parent: jayesh thakare <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2024-11-08 20:23 UTC (permalink / raw) To: jayesh thakare <[email protected]>; [email protected] 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 [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can we directly upgrade postgresql from 13 to 15.4 @ 2024-11-09 05:46 Achilleas Mantzios <[email protected]> parent: Christophe Pettus <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Achilleas Mantzios @ 2024-11-09 05:46 UTC (permalink / raw) To: [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. > ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-11-09 05:46 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-11-08 18:12 Can we directly upgrade postgresql from 13 to 15.4 jayesh thakare <[email protected]> 2024-11-08 18:16 ` Christophe Pettus <[email protected]> 2024-11-09 05:46 ` Achilleas Mantzios <[email protected]> 2024-11-08 20:23 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox