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/
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 |