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@sss.pgh.pa.us]
Sent: Wednesday, April 13, 2005 10:26 AM
To: Mohan, Ross
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] question about wal and point in time recovery


"Mohan, Ross" <RMohan@arbinet.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
todate.  Ideally someone would clean it up and make it into a contrib module so it could get into the source tree and
bemaintained properly ... 

            regards, tom lane