Thread: Upgrade postgres from v10 to v14

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

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@gmail.com> wrote:



Thanks ! 

On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.com> 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

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@yahoo.com> 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@gmail.com> wrote:



Thanks ! 

On Tue, Jan 11, 2022 at 2:20 PM Holger Jakobs <holger@jakobs.com> 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