Re: recover corrupt DB?

Tom Lane wrote:
> Craig Ringer <craig@postnewspapers.com.au> writes:
>> I've been wondering about this for a while. Why does Pg end up with the
>> database in an unusable, unrecoverable state after a disk-full error?
>
> It doesn't.  There must have been some other filesystem misfeasance
> involved in the OP's problem.

Cool - so it's definitely meant to handle disk-full fine. That's what  I
was concerned about.

These reports seem to come up a bit, with disk full issues resulting in
the need to pg_resetxlog, dump, and re-initdb, but I wouldn't be too
shocked if they all turned out to be on xfs or something like that.

--
Craig Ringer