Re: Converting WAL to SQL
| От | Fabrízio de Royes Mello |
|---|---|
| Тема | Re: Converting WAL to SQL |
| Дата | |
| Msg-id | CAFcNs+rzdh4kubb+varuBefdFhZxg4CDVVFaig9vSJtP8ZZPqQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Converting WAL to SQL (rajesh singarapu <rajesh.rs0541@gmail.com>) |
| Ответы |
Re: Converting WAL to SQL
Re: Converting WAL to SQL |
| Список | 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
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
В списке pgsql-hackers по дате отправления: