Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2

From: Venkata B Nagothi <nag1010(at)gmail(dot)com>
To: KGA Official <kga(dot)official(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2
Date: 2016-09-20 06:02:11
Message-ID: CAEyp7J_x9GFSM9jApbQbS+vS6D+23Rnhp95XBxFY=-4T=yNFfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message KGA Official 2016-09-20 06:21:38 Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2
Previous Message Adrian Klaver 2016-09-20 05:04:06 Re: We have a requirement to downgrade from PostgreSQL 9.5.4 to 9.5.2