--On torsdag, december 06, 2007 17.45.57 +0100 Palle Girgensohn
<girgen@xxxxxxxxxxxx> wrote:
--On torsdag, december 06, 2007 10.41.40 -0600 Scott Marlowe
<scott.marlowe@xxxxxxxxx> wrote:
On Dec 6, 2007 10:24 AM, Palle Girgensohn <girgen@xxxxxxxxxxxx> wrote:
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?
No.
Or from a file system snapshot as of now (five pm) + pg_xlog?
No.
So, I *must* have an image of the entire database, and I *must* have all
WAL files since the image snapshot was taken?
Is the real reason for the negative answer that there is a "hole" in the
pg_xlogs from 3 am - 9 am?
Palle
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
