Diffs in PG output vs WAL

From: V <avinash(at)verloop(dot)io>
To: pgsql-general(at)postgresql(dot)org
Subject: Diffs in PG output vs WAL
Date: 2022-09-01 17:14:24
Message-ID: CAAyVzMWd-Z2xMf7BY=TQfiZfAQM-ce9++R3Bg6=c2wqvZZ6ptw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2022-09-01 17:19:05 Re: Diffs in PG output vs WAL
Previous Message Ron 2022-09-01 14:36:14 Re: View definition changes after reloading pg_dump export