Re: question about wal and point in time recovery

Thank you!

( would send this to yer eddress directly, but it's decided
my biz email is a spam address, or somesuch:
<imail01.arbinet.com #5.7.1 SMTP; 550 5.7.1 Probable spam from 64.74.47.121
refused - see http://www.five-ten-sg.com/blackhole.php? )

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, April 13, 2005 10:26 AM
To: Mohan, Ross
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] question about wal and point in time recovery

"Mohan, Ross" <RMohan(at)arbinet(dot)com> writes:
> In any case, do you have a pointer to this R&R WAL tool?

I haven't posted it anywhere, but here is the 8.0 version. You'd build it something like this:

PGSQL=(location of PG source tree)
CC=gcc
CFLAGS=-Wall -O -I $(PGSQL)/src/include

xlogdump: xlogdump.c
$(CC) $(CFLAGS) -o xlogdump xlogdump.c $(PGSQL)/src/backend/utils/hash/pg_crc.c

It needs improvement to understand more WAL record types, but what it does has been sufficient for my debugging needs to date. Ideally someone would clean it up and make it into a contrib module so it could get into the source tree and be maintained properly ...

regards, tom lane