Feedback-ID: i76984098:Fastmail
Message-ID: <f8d7379b-e493-4d16-bf2f-4a3c9a06d30d@aklaver.com>
Date: Fri, 8 Nov 2024 12:23:03 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Can we directly upgrade postgresql from 13 to 15.4
To: jayesh thakare <thakarejayesh700@gmail.com>,
 pgsql-general@lists.postgresql.org
References: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAFhqqtwqeRM32f4uzzfYrZdYJkcKJP=XU=HrmFgeSEHHYhszwg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/f8d7379b-e493-4d16-bf2f-4a3c9a06d30d%40aklaver.com>
Precedence: bulk

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.klaver@aklaver.com