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-otA6psxn2vLd-okCAb7XvCCN93a02FrbE_JwoBNpxHQ@mail.gmail.com
Whole thread Raw
In response to Back-out V10 upgrade but keep new data  ("Rossi, Maria" <maria.rossi@jackson.com>)
Responses RE: Back-out V10 upgrade but keep new data
List pgsql-sql
Tree view
Check this out for CDC, haven't used it myself but I'm looking forward. 

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: "Rossi, Maria"
Date:
Subject: Back-out V10 upgrade but keep new data
Next
From: Rene Romero Benavides
Date:
Subject: Re: Back-out V10 upgrade but keep new data