Interpreting content of wal

From: Charles-Antoine Guillat-Guignard <xarli(at)xarli(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Interpreting content of wal
Date: 2009-10-23 11:52:48
Message-ID: 1256298768.32728.30.camel@tiki
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

I need to recover the content of WAL files, in order to see what
happened to a database, so I am trying to translate it from binary to
human-readable log. My goal is to be able to read the modifications that
were made to my database (the same way mysqlbinlog does for MySQL).

I tried using xlogdump (from
http://xlogviewer.projects.postgresql.org/index.html ), but i get the
following error for every WAL file :

__________
# /usr/local/postgres/bin/xlogdump 0000000100000018000000FE

0000000100000018000000FE:

Unexpected page info flags 0003 at offset 0
Skipping unexpected continuation record at offset 0
invalid record length at 18/FE000020
____________

I tried compiling xlogdump against PgSQL 8.1 and 8.2 (the WAL files are
from a 8.1 version), which lead to the same error, with all the WAL
files I have. I suspect an unattended file structure (version
mismatch?), though the versions seem to match (except the architecture,
i386 for my compiling and amd64 for the DB server).

Can anyone point me to a tool or a method allowing to read or decode to
text the content of WAL files?

Ty in advance

Charles-Antoine

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cjkalbente 2009-10-23 12:26:33 Re: Data migration tool certification
Previous Message Michael Nacos 2009-10-23 11:41:02 Re: leak in libpq, getpwuid