Re: recover corrupt DB? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: recover corrupt DB?
Date
Msg-id 200904231852.51317.peter_e@gmx.net
Whole thread Raw
In response to recover corrupt DB?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Responses Re: recover corrupt DB?
Re: recover corrupt DB?
List pgsql-general
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. ;-)


pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: pg_lsclusters error after pg_dropcluster
Next
From: Karsten Hilbert
Date:
Subject: Re: Help request to improve function performance