Re: Uber migrated from Postgres to MySQL

From: Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
To: Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Uber migrated from Postgres to MySQL
Date: 2016-07-28 14:50:59
Message-ID: CAJBB=EWFrmBHrfH7zHjOALBYBiMfGXsMP8+EB+xQNurZLkh3dQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 28, 2016 at 10:38 AM, Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> wrote:

> Sorry, what? You can rollback to previous version of software what you had.
>
> https://docs.oracle.com/cd/E11882_01/server.112/e23633/downgrade.htm#UPGRD007

Not so fast. This requires the db to be set in compatibility mode of
the lower version. Once that is removed, no downgrade is possible.

Also starting from Oracle 12 this downgrade option has been removed.
That is, you can't upgrade in-place from Or 11 to 12 and then
downgrade back. The only supported way is the restore from an old
backup (which is true for all products). I don't work in Oracle, but
got this clarified by someone who is an Oracle dba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Day, David 2016-07-28 14:53:44 Re: Server side backend permanent session memory usage ?
Previous Message Markus Kolb 2016-07-28 14:50:58 Re: Multiple NOTIFY is ignored