| From: | "J(dot) Hondius" <jhondius(at)rem(dot)nl> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Oops! Disaster recovery |
| Date: | 2010-01-12 10:47:21 |
| Message-ID: | 4B4C5339.2090308@rem.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I'm helping a customer using PostgreSQL 8.0/win who accidentally deleted
a lot of quite valuable data.
At that time they discovered no valid backup procedure was in place. (no
comment)
They have a real old manual backup, but lost of data would be lost.
This backup is to old to do forward PITR from with the current xlogs.
Long shot:
Is it possible to reconstruct the prior situation from the transaction
log by goin back to a previous checkpoint?
The xlog seems old enough to possibly hold the desired situation.
Please help!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Krajmalnik | 2010-01-14 00:51:51 | Question on moving data to new partitions |
| Previous Message | Achilleas Mantzios | 2010-01-12 08:43:34 | Re: Very simple password for DB administrator |