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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
