Thread: Any way to recover a lost db..
Please reply. a dumb question but just double checking for any possiblity.
On Thu, February 4, 2010 2:01 pm, Hilda Raymond wrote: > Please reply. a dumb question but just double checking for any possiblity. > Depends. What do you mean by 'lost'? Daniel T. Staal --------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. ---------------------------------------------------------------
As others have said it depends, but I thought I should mention if your ever in the position of having lost something unmount and turn off the hard disk straight away so no 'deleted file' gets overwritten! -- Michael On Thu, 4 Feb 2010, Hilda Raymond wrote: > Please reply. a dumb question but just double checking for any possiblity.>
--As of February 5, 2010 4:01:08 AM +0000, Hilda Raymond is alleged to have said: > Dropped it. --As for the rest, it is mine. I suspect without a backup you are probably in trouble. If you haven't used the disk (or at the very least haven't used it much), there is a chance it's still on there, and there are some recovery tools that might be able to read it off, by looking for places on the disk that have data but don't have directory entries. That'll be tedious, manual, and error-prone, but it *might* work. (And there are places that'll do it for you if you want.) If you have been using the disk since... Hope you have a good backup plan. (I'm not sure about one thing: I don't know if Postgres deletes the data immediately on a drop, or if it waits for the next vacuum. I strongly suspect the former, but I'm not an expert at that level.) Daniel T. Staal --------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. ---------------------------------------------------------------