public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: jayesh thakare <[email protected]>
To: [email protected]
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
Date: Fri, 8 Nov 2024 12:23:03 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
References: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>

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]

view thread (4+ messages)  latest in thread

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], [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