Back-out V10 upgrade but keep new data

From: "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com>
To: "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org>
Cc: "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com>
Subject: Back-out V10 upgrade but keep new data
Date: 2019-01-23 19:06:05
Message-ID: a08cae634742427385728ce0209d80fa@DC03PXMBP003.jacksonnational.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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<mailto:maria(dot)rossi(at)jackson(dot)com>
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rene Romero Benavides 2019-01-23 19:12:13 Re: Back-out V10 upgrade but keep new data
Previous Message Andrew Gierth 2019-01-23 06:38:55 Re: Converting from MySQL