pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-admin@postgresql.org.
Subject: Explore contents of WAL files
Date: Mon, 04 Apr 2011 09:30:49 -0600
Message-ID: <4D99E429.6020609@consistentstate.com> (raw)

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

Message-ID: <4D99E429.6020609@consistentstate.com>
Permalink:  ../4D99E429.6020609@consistentstate.com/
Also on:    postgresql.org/message-id/4D99E429.6020609@consistentstate.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: brianf@consistentstate.com, pgsql-admin@postgresql.org.
  Subject: Re: Explore contents of WAL files
  In-Reply-To: <4D99E429.6020609@consistentstate.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox