On Monday 26 November 2007 01:23, Gerhard Wiesinger wrote: > Hello! > > Since the pg_filedump utility manages only the database file I'm currently > writing a pg_xlog/pg_clog viewer. > > I'm looking for the documentation in: > // See src/include/access/xlog.h > // See src/include/access/xlog_internal.h > // See src/include/access/xlogdefs.h > // See src/backend/access/transam/xlog.c > > // See src/include/access/clog.h > // See src/backend/access/transam/clog.c > > // See src/include/access/rmgr.h > // See src/backend/access/transam/rmgr.c > > But I'm still having problems to get a suitable output: > 1.) pg_xlog: > a.) Reading XLogPageHeaderData or XLogLongPageHeaderData works well > b.) Afterwards a XLogRecord should be expected but the output doesn't look > suitable (e.g. CRC has 000000 in it in different files which is not > suitable) > I'll expect in b.): > * The overall layout of an XLOG record is: > * Fixed-size header (XLogRecord struct) > * rmgr-specific data > * BkpBlock > * backup block data > * BkpBlock > * backup block data > * ... > > Any ideas of the correct structure? > > > 2.) pg_clog: > I'm not sure what the correct structures of pg_clog are. > Any ideas? > > Thnx. > > Ciao, > Gerhard > > -- > http://www.wiesinger.com/ > > On Sat, 26 May 2007, Gerhard Wiesinger wrote: > > Hello! > > > > I think I found a proper utility for that: pg_filedump > > http://sources.redhat.com/rhdb/utilities.html > > > > Ciao, > > Gerhard > > > > -- > > http://www.wiesinger.com/ > > > > On Fri, 18 May 2007, Gerhard Wiesinger wrote: > >> Hello! > >> > >> Are there any tools available to dump the files of the pg_xlog, pg_clog, > >> ... directories in human readable format to understand how transaction > >> handling is done? > >> Have you looked at http://pgfoundry.org/projects/xlogviewer/ ? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
