|
Home > Archive > PostgreSQL Discussion > December 2005 > How to read wal?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Jure Ložar 2005-12-30, 8:23 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Tom Lane 2005-12-31, 8:23 pm |
| =?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
|
|
|
|
|