Actually I am using WAL files for designing a replication tool and I need to know if there is any method by which we can obtain sql statements executed in particular transaction id (xid)
Here is a block of information which I have from the processing of WAL file in pg_xlog directory
Here is a block of information which I have from the processing of WAL file in pg_xlog directory
Code:
INSERT INTO "16425" ([cur:0/192E8EAC, xid:1111, rmid:10(Heap), len:39/67, prev:0/112E8E68] insert: s/d/r:1663/16384/16425 blk/off:527/44 header: t_infomask2 3 t_infomask 2048 t_hoff 24 INSERT INTO "16425" ([cur:0/192E8EF0, xid:1111, rmid:10(Heap), len:39/67, prev:0/112E8EAC] insert: s/d/r:1663/16384/16425 blk/off:527/45 header: t_infomask2 3 t_infomask 2048 t_hoff 24