Thread: How to read wal?

Hi.

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.

Hopefully I chose the right list po post this.

Thanks in advance

Jure

=?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