Thread: pg_xlog

pg_xlog

From
"qmis"
Date:
Hi all

How can i read transactions from  "write ahead log "   pg_xlog  ?
It is possible ?

regards
S.W




Re: pg_xlog

From
Bruce Momjian
Date:
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073