Re: Upgrade postgres from v10 to v14

[Gaurav Anand <gaurav.anand@xxxxxxxxx>]

This upgrade will be taken up by many this year, so kindly share any observations, steps or workaround during the upgrade process

Thanks.

Regards,

Gaurav Anand

On Tue, Jan 11, 2022 at 8:23 PM Daulat <daulat.dba@xxxxxxxxx> wrote:

Hi Abbas,

Could you please share your migration steps /errors/prerequisites/post requisites etc.

Thanks

On Tue, Jan 11, 2022 at 6:08 PM abbas alizadeh <ramkly@xxxxxxxxx> wrote:

I recently upgrade some of our databases from 9.6 to 14.1. 

I used pg_upgrade and there wasn’t any diffrences in code level. Everything was perfect

Best regards

Abbas

On 11 Jan 2022, at 5:21 PM, Daulat <daulat.dba@xxxxxxxxx> wrote:



Thanks ! 

On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@xxxxxxxxxx> wrote:

Am 11.01.22 um 09:44 schrieb Daulat:
> Hello Team,
>
> We are planning to upgrade our existing Postgres v10 to  v14 .
> I need to know the best practices for upgrades and  major differences
> between PostgreSQL v10 and v14, primarily to identify code level impact.
>
> Thanks,
>
Hello,

Have a look at https://www.postgresql.org/about/featurematrix/ for the
differences between versions. For code level impact (which will be very
small, maybe non-existant), you may read the release notes of the
versions 11 thru 14.

https://www.postgresql.org/docs/11/release.html
https://www.postgresql.org/docs/12/release.html
https://www.postgresql.org/docs/13/release.html
https://www.postgresql.org/docs/14/release.html

The topic upgrading is well described at
https://www.postgresql.org/docs/current/upgrading.html

If your database isn't large, I'd recommend pg_dump + psql, but if it's
large, pg_upgrade is a must.

Regards,

Holger

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

This communication is confidential and subject to and governed by Saama’s Electronic Communications Disclaimer.