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:12:13
Message-ID: CANaGW0-otA6psxn2vLd-okCAb7XvCCN93a02FrbE_JwoBNpxHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Check this out for CDC, haven't used it myself but I'm looking forward.
https://debezium.io/

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rene Romero Benavides 2019-01-23 19:31:43 Re: Back-out V10 upgrade but keep new data
Previous Message Rossi, Maria 2019-01-23 19:06:05 Back-out V10 upgrade but keep new data