From: | Bo Guo <bo(dot)guo(at)gisticinc(dot)com> |
---|---|
To: | Christophe Pettus <xof(at)thebuild(dot)com> |
Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
Subject: | Re: Getting transaction details from the WAL? |
Date: | 2021-05-23 02:36:52 |
Message-ID: | 0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
This is great, Thanks, Chrsitophe!
Bo
On 5/22/21 7:03 PM, Christophe Pettus wrote:
>
>> On May 22, 2021, at 19:00, Bo Guo <bo(dot)guo(at)gisticinc(dot)com> wrote:
>>
>> I am wondering if it is possible to get content changes to a particular table from a point-in-time by exploring the WAL or any other artifacts relating to transaction management.
> Perhaps the easiest way to do this is to use logical decoding, which you can use to capture changes from the WAL, converting them to other formats. While it forms the basis of logical replication, there are other plug-ins to the framework. You might look at wal2json:
>
> https://github.com/eulerto/wal2json
>
> or the test plugin in contrib/
>
> https://www.postgresql.org/docs/current/test-decoding.html
From | Date | Subject | |
---|---|---|---|
Next Message | Yambu | 2021-05-24 03:41:41 | Index creation |
Previous Message | Christophe Pettus | 2021-05-23 02:03:25 | Re: Getting transaction details from the WAL? |