[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] How to read wal?
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2005-12-31 20:09:23
Message-ID: 21085.1136059763 () sss ! pgh ! pa ! us
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
[prev in list] [next in list] [prev in thread] [next in thread]