Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2 - Mailing list pgsql-general

From KGA Official
Subject Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2
Date
Msg-id CAFtx=TkmxGhos8-C1t799in6v8nQfuUTUNoSp66K2fenaQ3Xsg@mail.gmail.com
Whole thread Raw
In response to Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2  (Venkata B Nagothi <nag1010@gmail.com>)
Responses Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Hi Andreas, Adrian and Venkata,

Regarding "are you really going to downgrade again"?
The upgraded postgres will be bundled along with product code changes and other products. So, if someone finds product issues, they will roll back everything together.
So, essentially, yes. One requirement of the roll out is that it be possible to roll-back.

It is understood that the Bugs/CVEs will be reverted by the downgrade. In any-case, the downgrade will be temporary till the issue is resolved and the bundle upgraded again.

Andreas,

> But trust me, there is problem with the new version.

Do you see any major defects with the new version?

Thx,
Regards
Akshay


On Tue, Sep 20, 2016 at 11:32 AM, Venkata B Nagothi <nag1010@gmail.com> wrote:

We are currently running at 9.5.2 and plan to upgrade to 9.5.4, but our change requirement needs to plan for a downgrade with data preservation, before upgrade is authorized. 

Thus, I am asking this: Is it safe to downgrade from 9.5.4 to 9.5.2 by simply replacing the binaries? We will keep the data folder same.

Technically, that should not be a problem. The only thing to foresee would be that, if you are upgrading to fix any BUGs or CVEs, then downgrading would revert the fixes. 
Just curious to know - when you say downgrade, do you mean to say there has to be a back-out plan in place if the upgrade fails ? or you are really going to downgrade again ?

Regards,
Venkata B N

Fujitsu Australia

pgsql-general by date:

Previous
From: Venkata B Nagothi
Date:
Subject: Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2
Next
From: Michael Paquier
Date:
Subject: Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2