agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Bo Guo <bo.guo@gisticinc.com>
To: Christophe Pettus <xof@thebuild.com>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Getting transaction details from the WAL?
Date: Sat, 22 May 2021 19:36:52 -0700
Message-ID: <0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com> (raw)
In-Reply-To: <72F6C54D-3787-4016-B765-45672851FD72@thebuild.com>
References: <1510da2a-da65-3af7-4a83-88f5856de1fb@gisticinc.com>
	<52014f4e-b1d5-06fd-660e-b58f4f1188de@gisticinc.com>
	<72F6C54D-3787-4016-B765-45672851FD72@thebuild.com>

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.guo@gisticinc.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

view thread (3+ messages)

Message-ID: <0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com>
Permalink:  ../0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com/
Also on:    postgresql.org/message-id/0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bo.guo@gisticinc.com, xof@thebuild.com, pgsql-sql@lists.postgresql.org
  Subject: Re: Getting transaction details from the WAL?
  In-Reply-To: <0d35264c-aa83-e6aa-1bf9-006495581f82@gisticinc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox