Re: Converting WAL to SQL - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Converting WAL to SQL
Date
Msg-id CAFcNs+rzdh4kubb+varuBefdFhZxg4CDVVFaig9vSJtP8ZZPqQ@mail.gmail.com
Whole thread Raw
In response to Converting WAL to SQL  (rajesh singarapu <rajesh.rs0541@gmail.com>)
Responses Re: Converting WAL to SQL
Re: Converting WAL to SQL
List pgsql-hackers

On Tue, Jan 4, 2022 at 9:22 AM Michael Paquier <michael@paquier.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

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [PATCH] allow src/tools/msvc/*.bat files to be called from the root of the source tree
Next
From: Dag Lem
Date:
Subject: Re: daitch_mokotoff module