Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\))
Subject: Re: Getting transaction details from the WAL?
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <52014f4e-b1d5-06fd-660e-b58f4f1188de@gisticinc.com>
Date: Sat, 22 May 2021 19:03:25 -0700
Cc: pgsql-sql@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <72F6C54D-3787-4016-B765-45672851FD72@thebuild.com>
References: <1510da2a-da65-3af7-4a83-88f5856de1fb@gisticinc.com>
 <52014f4e-b1d5-06fd-660e-b58f4f1188de@gisticinc.com>
To: Bo Guo <bo.guo@gisticinc.com>
Archived-At: 
 <https://www.postgresql.org/message-id/72F6C54D-3787-4016-B765-45672851FD72%40thebuild.com>
Precedence: bulk


> On May 22, 2021, at 19:00, Bo Guo <bo.guo@gisticinc.com> wrote:
>=20
> 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=