Re: 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