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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

lost data, possible playback?



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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group