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@xxxxxxxxxxxxx] Sent: Wednesday, April 13, 2005 10:26 AM To: Mohan, Ross Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] question about wal and point in time recovery "Mohan, Ross" <RMohan@xxxxxxxxxxx> 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
