Re: Converting WAL to SQL

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Converting WAL to SQL
Date: 2021-12-29 10:04:03
Message-ID: 86079252-8c5c-5ef4-0181-7ef169765371@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 29.12.21 07:18, rajesh singarapu wrote:
> I am wondering if we have a mechanism to convert WAL records to SQL
> statements.
>
> I am able to use logical decoders like wal2json or test_decoding for
> converting WAL to readable format, but I am looking for a way to convert
> WAL to sql statements.

Using pglogical in SPI mode has such a logic.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2021-12-29 10:06:41 Re: UNIQUE null treatment option
Previous Message Peter Eisentraut 2021-12-29 09:46:52 Re: Foreign key joins revisited