agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedGetting transaction details from the WAL?
3+ messages / 2 participants
[nested] [flat]
* Getting transaction details from the WAL?
@ 2021-05-23 02:00 Bo Guo <bo.guo@gisticinc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bo Guo @ 2021-05-23 02:00 UTC (permalink / raw)
To: pgsql-sql@lists.postgresql.org
Hello, PostgreSQL community!
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.
Any help or comment is appreciated!
Cheers,
Bo
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting transaction details from the WAL?
@ 2021-05-23 02:03 Christophe Pettus <xof@thebuild.com>
parent: Bo Guo <bo.guo@gisticinc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Christophe Pettus @ 2021-05-23 02:03 UTC (permalink / raw)
To: Bo Guo <bo.guo@gisticinc.com>; +Cc: pgsql-sql@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting transaction details from the WAL?
@ 2021-05-23 02:36 Bo Guo <bo.guo@gisticinc.com>
parent: Christophe Pettus <xof@thebuild.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bo Guo @ 2021-05-23 02:36 UTC (permalink / raw)
To: Christophe Pettus <xof@thebuild.com>; +Cc: pgsql-sql@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-05-23 02:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-23 02:00 Getting transaction details from the WAL? Bo Guo <bo.guo@gisticinc.com>
2021-05-23 02:03 ` Christophe Pettus <xof@thebuild.com>
2021-05-23 02:36 ` Bo Guo <bo.guo@gisticinc.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox