Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id E48F61337B43
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  4 Apr 2011 12:37:27 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 44684-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  4 Apr 2011 15:37:20 +0000 (UTC)
X-Greylist: delayed 00:07:30.049775 by SQLgrey-1.7.6
Received: from mail-vx0-f179.google.com (mail-vx0-f179.google.com
	[209.85.220.179])
	by mail.postgresql.org (Postfix) with ESMTP id 4C1F41337A5D
	for <pgsql-admin@postgresql.org.>; Mon,  4 Apr 2011 12:37:20 -0300 (ADT)
Received: by vxi40 with SMTP id 40so4627195vxi.38
	for <pgsql-admin@postgresql.org.>; Mon, 04 Apr 2011 08:37:19 -0700 (PDT)
Received: by 10.220.187.76 with SMTP id cv12mr2001365vcb.128.1301930988426;
	Mon, 04 Apr 2011 08:29:48 -0700 (PDT)
Received: from sidon.consistentstate.com
	(173-164-51-9-colorado.hfc.comcastbusiness.net [173.164.51.9])
	by mx.google.com with ESMTPS id x29sm1131105vcf.2.2011.04.04.08.29.46
	(version=SSLv3 cipher=OTHER); Mon, 04 Apr 2011 08:29:47 -0700 (PDT)
Message-ID: <4D99E429.6020609@consistentstate.com>
Date: Mon, 04 Apr 2011 09:30:49 -0600
From: Brian Fehrle <brianf@consistentstate.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US;
	rv:1.9.2.14) Gecko/20110221 Lightning/1.0b2 Thunderbird/3.1.8
MIME-Version: 1.0
To: pgsql-admin@postgresql.org.
Subject: Explore contents of WAL files
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201104/36
X-Sequence-Number: 37217

Hi all,
     I've done a ton of searching for a solution to this several times 
before, but never found anything that could help.

I need to take a look at what is inside a WAL file, perhaps not exactly 
everything in it, even a summary would be nice (such as how many 
transactions or types of activity).

I've looked at xlogviewer and xlogdump, but it seems those projects have 
been abandoned since later 2006. The latest version they report support 
for is 8.2.

Are there any tools out there that would work with WAL files from a 8.4 
cluster on a 64 bit machine?

Thanks in advance,
     Brian F