Re: Back-out V10 upgrade but keep new data

From: Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com>
To: "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com>
Cc: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Back-out V10 upgrade but keep new data
Date: 2019-01-23 19:31:43
Message-ID: CANaGW0-Dg7KTs0=X1GViVZHNUQQ=xzdgaaBeQbOzCgSDYMgWJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

You also have the option of using multi-master replication with Bucardo,
but last time we tried to use it with the latest PG versions (10), we ran
into several issues, it seems the project hasn't been very active in recent
years.

On Wed, Jan 23, 2019 at 1:06 PM Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
wrote:

> Hi,
>
>
>
> If I upgrade Postgres from V9.3 to V10, then need to roll-back to V9.3
> after data been entered, is there a way for me to save the new data so that
> I can re-apply it to the V9.3? After I restore my V9.3 backup, can I
> simply replay the V10 log unto V9.3? What are my options, if any?
>
>
>
> Thanks.
>
>
>
> *Maria A Rossi*
>
> Database Administration
>
> Jackson National Life
>
> email: maria(dot)rossi(at)jackson(dot)com
> cell phone: 517.256.4392
>
> work phone: 517.367.3099
> work phone extension: 23099
>
>
>

--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rossi, Maria 2019-01-23 19:51:48 RE: Back-out V10 upgrade but keep new data
Previous Message Rene Romero Benavides 2019-01-23 19:12:13 Re: Back-out V10 upgrade but keep new data