Re: How to read wal? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to read wal?
Date
Msg-id 21085.1136059763@sss.pgh.pa.us
Whole thread Raw
In response to How to read wal?  (Jure Ložar <jure.lozar@madalbal.si>)
List pgsql-general
=?UTF-8?B?SnVyZSBMb8W+YXI=?= <jure.lozar@madalbal.si> writes:
> I have a big problem. I dropped wrong table. I do have very recent dump,
> but I would need to read wal (write ahead log) files somehow, to see
> last 60 entries that were made. Then I can enter them manually.
> Is there any way to make wal files more readable? Or is there something
> else that I can do? I read that it is not possible to combine them with
> dump. I do not have any usefull logs and wal files are my last hope.

There is an "xlogdump" program in the PG mail archives that might help,
but it only understands the record headers not the contained data.
It would take quite a lot of work to get to the point of being able to
reconstruct the source data being inserted.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: solving wraparound
Next
From: Tom Lane
Date:
Subject: Re: MDX support in postgresql