Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade from PostgreSQL version 10 to 16 - Mailing list pgsql-admin

From vignesh kumar
Subject Re: Upgrade from PostgreSQL version 10 to 16
Date
Msg-id MN0PR20MB49125F887669AECEAD449B8F87F82@MN0PR20MB4912.namprd20.prod.outlook.com
Whole thread Raw
In response to Re: Upgrade from PostgreSQL version 10 to 16  (Kashif Zeeshan <kashi.zeeshan@gmail.com>)
List pgsql-admin
Tree view
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 

From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Sent: Thursday, May 23, 2024 9:11:32 PM
To: Harish Harish <hpt3009@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Upgrade from PostgreSQL version 10 to 16
 

On Thu, May 23, 2024 at 8:15 PM Harish Harish <hpt3009@gmail.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

pgsql-admin by date:

Previous
From: vignesh kumar
Date:
Subject: Re: Questions on recovery situations (not urgent)
Next
From: vignesh kumar
Date:
Subject: Re: Autovacuum log messges re: index scans