Skip site navigation (1) Skip section navigation (2)

Re: pg_xlog

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: qmis <qmis(at)nospamblitz(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_xlog
Date: 2004-02-28 22:59:00
Message-ID: 200402282259.i1SMx0i22086@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
qmis wrote:
> Hi all
> 
> How can i read transactions from  "write ahead log "   pg_xlog  ?
> It is possible ?

No, it is all binary and read only on startup after a crash. If you want
to interpret it, you have to read the backend code that reads it during
recovery.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

  • pg_xlog at 2004-02-21 14:46:51 from qmis

pgsql-hackers by date

Next:From: Gavin M. RoyDate: 2004-02-29 00:33:38
Subject: Re: [HACKERS] Any Gentoo users interested in a slotted PostgreSQL
Previous:From: Bruce MomjianDate: 2004-02-28 22:47:38
Subject: Re: Pl/Java - next step?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group