Postgres Pro
Downloads
Home   >   mailing lists

Re: Back-out V10 upgrade but keep new data - Mailing list pgsql-sql

From Rene Romero Benavides
Subject Re: Back-out V10 upgrade but keep new data
Date
Msg-id CANaGW0-Dg7KTs0=X1GViVZHNUQQ=xzdgaaBeQbOzCgSDYMgWJg@mail.gmail.com
Whole thread Raw
In response to Back-out V10 upgrade but keep new data  ("Rossi, Maria" <maria.rossi@jackson.com>)
List pgsql-sql
Tree view
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.rossi@jackson.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.rossi@jackson.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/

pgsql-sql by date:

Previous
From: Rene Romero Benavides
Date:
Subject: Re: Back-out V10 upgrade but keep new data
Next
From: "Rossi, Maria"
Date:
Subject: RE: Back-out V10 upgrade but keep new data