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

Oops! Disaster recovery

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 (view raw or flat)
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!

pgsql-admin by date

Next:From: Benjamin KrajmalnikDate: 2010-01-14 00:51:51
Subject: Question on moving data to new partitions
Previous:From: Achilleas MantziosDate: 2010-01-12 08:43:34
Subject: Re: Very simple password for DB administrator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group