Re: Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

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/1363155 tid 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