Re: Any way to recover a lost db..

--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.
---------------------------------------------------------------