Re: Upgrade from PostgreSQL version 10 to 16

Upgrade is just not only on filesystem but also you need to see what are all the heirarchial changes. So go through change log then decide your upgrade workflow.

Upgrade 10 to 12 --> test your app
Upgrade 12 to 14 --> test your app
Upgrade 14 to 16 --> test your app

In this way you can ensure that app is functional throughout the heirachies and you can rely on data compatibility

Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
Sent: Thursday, May 23, 2024 9:11:32 PM
To: Harish Harish <hpt3009(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Upgrade from PostgreSQL version 10 to 16

Hi Harish

Please consult the following documentation.

https://www.postgresql.org/docs/current/pgupgrade.html
https://gist.github.com/truemogician/610300dd8e86f7a8ad01f73b9da1ff1a
https://www.postgresql.org/docs/9.0/install-upgrading.html

Regards
Kashif Zeeshan
Bitnine Global

On Thu, May 23, 2024 at 8:15 PM Harish Harish <hpt3009(at)gmail(dot)com<mailto:hpt3009(at)gmail(dot)com>> wrote:
Dear Admins,

We are planning to upgrade PostgreSQL Server which is currently running on Version 10 to Version 16 on windows.

Kindly help with any upgrade documentation for PostgreSQL server on Windows.

Thanks in advance for your help and support.

Best regards,
Hari