Looking at the contents of a WAL file

From: "Winning Runner" <runner(at)winning(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Looking at the contents of a WAL file
Date: 2011-08-26 23:20:10
Message-ID: 20110826232011.166460@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres 9.0 on Solaris 10. Is there any meaningful way to check the contents of a WAL file? I had a server run out of space and I wanted to check the WAL files to see what was going on that filled up the disk space. No errors in the log file so whatever was running was running "error free" until the space was all used up. Server is down right now. I assume the WAL files are mostly binary files but I was able to cat the last WAL file to the strings utility and see some text which gave me some more clues.

Browse pgsql-general by date

  From Date Subject
Next Message John Moran 2011-08-27 00:40:57 Performing upgrade to latest minor release using PGDG RPMs
Previous Message Andy Chambers 2011-08-26 22:53:45 Array syntax in the copier