Обсуждение: Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

On Sun, Feb 9, 2014 at 10:02 PM, Adarsh Sharma <eddy.adarsh@gmail.com> wrote:
> I need to use xlogdump to analyse my xlog files in postgresql to understand
> why there are so much xlog generation on Master.


Only PostgreSQL is supported. EDB's product is not.

--
Regards,
Peter Geoghegan

On Wed, Feb 12, 2014 at 5:19 PM, Adarsh Sharma <eddy.adarsh@gmail.com> wrote:
> Below link is little helpful :-
>
> http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-pg_xlogdump/
Postgres core includes pg_xlogdump since 9.3 and not xlogdump. As
their outputs are a bit different you should directly contact the
maintainer xlogdump if you begin playing with it. Saying that, I'd
guess that the output of s/d/r means tablespace/database/relation. So
if you cannot find those oids it means that they have been deleted at
a point later than the record you are looking at.

Regards,
--
Michael

Adarsh Sharma escribió:

> [cur:1835/26FAFEF8, xid:471303469, rmid:11(Btree), len/tot_len:18/5754, info:8, prev:1835/26FAFEB0] insert_leaf:
s/d/r:1663/1228184/1363155tid 28366/20 

> Is dere any document where i can co-relate this tid with relations/indexes
> in the database. I tried but not able to find :-
>
> wap_prod_adserve=# SELECT relname, oid FROM pg_class where oid=1363155 ;
>  relname | oid
> ---------+-----
> (0 rows)

Probably the reason you don't find any rows is because you're querying
the wrong column.  The "r" stands for relfilenode, and thus you must use
relfilenode in the WHERE clause, not oid:

SELECT relname, oid FROM pg_class where relfilenode=1363155 ;

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

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