Re: recover corrupt DB?

On Thursday 23 April 2009 18:30:27 Dan Armbrust wrote:
> I had a test system (read as not backed up, sigh) which had the disk
> go full while PostgreSQL was loaded, consequently, PostgreSQL will no
> longer start.
>
> It is logging an error about detecting an invalid shutdown, trying to
> replay something, and then an error about not being able to open a
> file it is looking for.

Knowing what file would help analyze this.  In general, pg_resetxlog would be
the tool to try here.  Don't panic yet. ;-)