Explore contents of WAL files

From: Brian Fehrle <brianf(at)consistentstate(dot)com>
To: pgsql-admin(at)postgresql(dot)org(dot)
Subject: Explore contents of WAL files
Date: 2011-04-04 15:30:49
Message-ID: 4D99E429.6020609@consistentstate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-04-04 16:02:13 Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)
Previous Message Glyn Astill 2011-04-04 15:28:58 Re: Bloated indexes from pg_restore? (Was: Index fillfactor changed in pg9?)