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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly