Postgres Pro
Downloads
Home   >   mailing lists

Diffs in PG output vs WAL - Mailing list pgsql-general

From V
Subject Diffs in PG output vs WAL
Date
Msg-id CAAyVzMWd-Z2xMf7BY=TQfiZfAQM-ce9++R3Bg6=c2wqvZZ6ptw@mail.gmail.com
Whole thread Raw
Responses Re: Diffs in PG output vs WAL
List pgsql-general
Tree view
I am playing with pgoutput and logical replication. With wal2json, I could capture the old values before the row was updated. I am unable to figure out how to do that with pgoutput. Does pgoutput even support this?

Relevant info from wal2json:

> Also, UPDATE/DELETE old row versions can be accessed depending on the configured replica identity
> All of the new/old tuples are available in the JSON object.

https://github.com/eulerto/wal2json

I want new/old tuples with pgoutput. how?

--
Avinash

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: View definition changes after reloading pg_dump export
Next
From: Christophe Pettus
Date:
Subject: Re: Diffs in PG output vs WAL