On Fri, Feb 14, 2014 at 3:14 PM, Adarsh Sharma <eddy.adarsh@gmail.com> wrote:
> Yes. Able to retrieve table names now.
>
> I am reviewing the xlogdump output. Is dere any way where i can understand
> what is the meaning of these keywords in it.
>
> [root@1002 tmp]# xlogdump pg_xlog/* > fullanalysis.txt
> [root@1002 tmp]# cat fullanaysis.txt | awk '{print $7}' | sort | uniq
> XLP_BKP_REMOVABLE
> bkpblock[1]:
> bkpblock[2]:
> commit_compact
> create
> delete:
> heap2_multi_insert:
> hot_update:
> inplace:
> insert_leaf:
> insert_upper:
> newpage:
> newroot:
> offset
> reuse_page:
> seq
> split_l:
> split_l_root:
> split_r:
> split_r_root:
> standby
> update(init):
> update:
Even if it is easy to guess to which WAL operations all those terms
refer to, referring to the source code is easier IMO:
https://github.com/snaga/xlogdump/blob/master/xlogdump_rmgr.c
Regards,
--
Michael