Re: upgrade postgres 9.5 to 9.6 - Mailing list pgsql-general

From Ron
Subject Re: upgrade postgres 9.5 to 9.6
Date
Msg-id 71cc2bdf-cf21-b89b-2811-94b1193efc4c@gmail.com
Whole thread Raw
In response to Re: upgrade postgres 9.5 to 9.6  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
On 1/15/21 9:17 AM, Thomas Kellerer wrote:
[snip]
Is there a reason you are upgrading to 9.6 and not 12 or 13?

The application software vendor might only certify the application on 9.6.
Or management, in their infinite "wisdom", might insist on a One-version upgrade.
Or 9.6 might be the default version in the distro they're migrating to, and Security Policy dictates that No Outside Software is allowed.  (Last year, I watched in horror as a database was upgraded from 8.4 to 9.2 for that very reason.)

9.6 will be end-of-live this November (in 10 months), you will have to do another upgrade then.

You'd be shocked to see how much data is pumped through old Postgresql databases.  "It works, so we're not going to fix it."  And they don't want to pony up for a new version of the application, and spend the money (manpower and h/w resources) validating it.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Atul Kumar
Date:
Subject: Re: Accounting for between table correlation
Next
From: svsn raju
Date:
Subject: Best tools to monitor and fine tune postgres