"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
Attachment:
bin7DsbIaCsYH.bin
Description: xlogdump.c.gz