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
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
On Fri, Feb 14, 2014 at 3:14 PM, Adarsh Sharma eddy.ada...@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
Below link is little helpful :-
http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-pg_xlogdump/
Thanks
On Wed, Feb 12, 2014 at 5:19 PM, Adarsh Sharma eddy.ada...@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
Hi Peter,
Thanks for your reply. I Complied xlogdump successfully with Pg-9.2 and now
i am using it to parse EDB's pg_xlog files and i am able to do that. Below
are the details :
[cur:1835/26FAE218, xid:471303469, rmid:9(Heap2), len/tot_len:24/6900,
info:24, prev:1835/26FAD6D8] bkpblock[1]:
Hi,
Any body faced the similar issue while compiliing xlogdump :-
[root@db1002 xlogdump]# make
/usr/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv strlcpy.o xlogdump.o
On Sun, Feb 9, 2014 at 10:02 PM, Adarsh Sharma eddy.ada...@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
--
Sent