Skip site navigation (1) Skip section navigation (2)

Re: How to read wal?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jure Ložar <jure(dot)lozar(at)madalbal(dot)si>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to read wal?
Date: 2005-12-31 20:09:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
=?UTF-8?B?SnVyZSBMb8W+YXI=?= <jure(dot)lozar(at)madalbal(dot)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

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2005-12-31 20:21:08
Subject: Re: MDX support in postgresql
Previous:From: Joshua D. DrakeDate: 2005-12-31 19:35:47
Subject: Re: solving wraparound

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group