lost data, possible playback?

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: kudo(at)pingpong(dot)net
Subject: lost data, possible playback?
Date: 2007-12-06 16:24:29
Message-ID: 9FD29C9B828B9182011BDDF5@rambutan.pingpong.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

A user accidentally deleted some results (i.e. tuples in a postgresql
database) created this morning.

I have pg_xlog from about 9 o'clock until now. I have a pg_dump from ab out
3 o'clock this morning.

The results where created from about nine o'clock until noon, when the user
accidentally removed the results.

Would it be possible to replay the WAL logs and get the results from
pg_xlog + the dump? Or from a file system snapshot as of now (five pm) +
pg_xlog?

Regards,
Palle

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2007-12-06 16:41:40 Re: lost data, possible playback?
Previous Message Alvaro Herrera 2007-12-05 16:38:28 Re: Enhancement request