Re: recover corrupt DB?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
Subject: Re: recover corrupt DB?
Date: 2009-04-23 15:52:51
Message-ID: 200904231852.51317.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. ;-)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zach cruise 2009-04-23 17:21:45 Re: how to search for relation by name?
Previous Message Willy-Bas Loos 2009-04-23 15:44:43 Re: pg_lsclusters error after pg_dropcluster