Re: Uber migrated from Postgres to MySQL - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Uber migrated from Postgres to MySQL
Date
Msg-id 20160727164724.GB27332@momjian.us
Whole thread Raw
In response to Re: Uber migrated from Postgres to MySQL  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Responses Re: Uber migrated from Postgres to MySQL  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Re: Uber migrated from Postgres to MySQL  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
On Wed, Jul 27, 2016 at 12:33:27PM -0400, Rakesh Kumar wrote:
> On Wed, Jul 27, 2016 at 11:45 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> > I agree, but I am not sure how to improve it.  The big complaint I have
> > heard is that once you upgrade and open up writes on the upgraded
> > server, you can't re-apply those writes to the old server if you need to
> > fall back to the old server.  I also don't see how to improve that either.
>
> doesn't and pg_logical solve this by logically replicating and allowing for
> different architecture/version between the replication nodes ?

Yes.  I was saying I don't know how to improve pg_upgrade to address it.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Rakesh Kumar
Date:
Subject: Re: Uber migrated from Postgres to MySQL