Re: Rollback using WAL files?

On 1/26/07, M.A. Oude Kotte <marc(at)solcon(dot)nl> wrote:
> Now I've found the WAL files in the pg_xlog directory, and started
> browsing around for documentation on what I can do with those. But all I
> can find is that you can use them to restore your database after a crash
> or a custom backup. But I would like to do it the other way around (not
> use them to restore a database, but to roll it back entirely a few
> days). I have 4 WAL files, from last Tuesday to today. Can I use these
> files to ROLLBACK the current database, so that it's restored to the
> situation it was in on Tuesday?

probably not. While such things are possible with WAL files, it is
only for a relatively short duration unless your server is extremely
inactive or you planned for this contingency in advance -- by setting
up a a PITR snapshot and archiving as many days WAL files back as you
would like to be able to go back in time. I'm guessing you didn't do
this.

Next we look at standard dumps (pg_dump) and possibly logs (are you
logging statements?) to recover your data. If those don't produce
results, and you have no other way of recovering your information,
this has officially become a learning experience :(.

merlin