| From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Converting WAL to SQL |
| Date: | 2022-01-04 13:47:47 |
| Message-ID: | CAFcNs+rzdh4kubb+varuBefdFhZxg4CDVVFaig9vSJtP8ZZPqQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 4, 2022 at 9:22 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Wed, Dec 29, 2021 at 08:50:23AM -0300, Fabrízio de Royes Mello wrote:
> > Try this:
> > https://github.com/michaelpq/pg_plugins/tree/main/decoder_raw
>
> You may want to be careful with this, and I don't know if anybody is
> using that for serious cases so some spots may have been missed.
>
I used it in the past during a major upgrade process from 9.2 to 9.6.
What we did was decode the 9.6 wal files and apply transactions to the
old 9.2 to keep it in sync with the new promoted version. This was our
"rollback" strategy if something went wrong with the new 9.6 version.
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dag Lem | 2022-01-04 13:49:11 | Re: daitch_mokotoff module |
| Previous Message | Andrew Dunstan | 2022-01-04 13:37:46 | Re: [PATCH] allow src/tools/msvc/*.bat files to be called from the root of the source tree |