Re: Back-out V10 upgrade but keep new data
| От | Rene Romero Benavides |
|---|---|
| Тема | Re: Back-out V10 upgrade but keep new data |
| Дата | |
| Msg-id | CANaGW0-Dg7KTs0=X1GViVZHNUQQ=xzdgaaBeQbOzCgSDYMgWJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Back-out V10 upgrade but keep new data ("Rossi, Maria" <maria.rossi@jackson.com>) |
| Список | 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.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.4392work phone: 517.367.3099
work phone extension: 23099
В списке pgsql-sql по дате отправления: