创建测试表

DROP TABLE IF EXISTS t01;
CREATE TABLE t01(id int,name varchar(10));

更新数据

BEGIN;
SELECT txid_current(),sys_current_wal_lsn(),
sys_walfile_name(sys_current_wal_lsn());
INSERT INTO t01 VALUES(100,'first row');
UPDATE t01 SET id=1000 WHERE id=100;
DELETE t01 WHERE id=1000;
end;

用sys_xlogdump挖掘日志位置的内容

sys_waldump -s 1/530000D0 $KINGBASE_DATA/sys_wal/000000010000000100000053